Error in SQL Syntax

[Mary Meer]

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

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

[Dormilich]

you forgot to define, what to select. e.g. SELECT `id` FROM `student`

[irfanmodan]

you forgot to define column name, e.g. SELECT `name` FROM `student`

[Rekha Kumaran]

U missed the column name in the select statement.
SELECT * FROM student WHERE name LIKE '$s%' "

[Dormilich]

I think after the 2nd repetition the OP knows the solution now.