Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near '' At Line 1

Solution 1:

You seem to have an extra comma in you columns and your table name in quotes, try changing this line:

$sql="INSERT INTO 'applicant' (user,name,number,) VALUES('$user','$name','$number')";

To this

$sql="INSERT INTO applicant (user,name,number) VALUES('$user','$name','$number')";

I believe the issue is here (user,name,number) and here 'applicant'

Solution 2:

Try removing the quote marks from the table names so for example:

$result3 = mysql_query("SELECT * FROM 'members' where user='$user'");

becomes:

$result3 = mysql_query("SELECT * FROM members where user='$user'");

Share