You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM student WHERE name LIKE 'a%'' at line 1
Could you help here is the query cannot figure out where the problem is
Could you help here is the query cannot figure out where the problem is
Code:
if(isset($_GET['n'])){ $s=$_GET['n']; $query="SELECT FROM student WHERE name LIKE '$s%' "; $result=mysql_query($query,$db) or die (mysql_error() ); echo $result; $string=''; while($row = mysql_fetch_assoc($result)){ $string.= $row['name']; } echo $string; }else{ echo 'wrong GET keywoord'; }//ifisset
Comment