求助，查询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"]."%'" 后面没有;