ÇóÖú£¬²éѯ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"]."%'" ºóÃæûÓÐ;