查询MYSQL问题

查询MYSQL问题

代码如下，有什么问题，请高手指出
<?php
if ( $_GET['botton1'] == "搜索" ) {
$mysqli=new mysqli("localhost","root","root","school");
$query="SELECT sname,sc.sno,deptno,cname,cnum,cdept FROM sc,student WHERE sc.sno=student.sno and sc.sno like '".$_GET["s"]."%'"
$result=$mysqli->query($query,MYSQLI_STORE_RESULT);
while(list($sname,$sc.sno,$deptno,$cname,$cnum,$cdept)=$result->fetch_row())
printf("%d %d %d %d %d %d <br />",$sname,$sc.sno,$deptno,$cname,$cnum,$cdept);
}

?>

$query="SELECT sname,sc.sno,deptno,cname,cnum,cdept FROM sc,student WHERE sc.sno=student.sno and sc.sno like '".$_GET["s"]."%'" 后面没有;