There is something wrong with this SQL.

$sql = "SELECT * from student where studentid={$studentid} and likeclassid={$classid}";

Ps:likeclassid is a full field name

You have a error in your SQL syntax; Check the manual, corresponds to your MySQL server version for the right syntax to use near ' and likeclassid=1176 ' at Line 1

Reply content:

$sql = "SELECT * from student where studentid={$studentid} and likeclassid={$classid}";

Ps:likeclassid is a full field name

You have a error in your SQL syntax; Check the manual, corresponds to your MySQL server version for the right syntax to use near ' and likeclassid=1176 ' at Line 1

Remove the curly braces and do not match the format with a few spaces after the like

The syntax should be classid like {$classid}
But since it's like it's going to blur the match, depending on what you want to match the content using%,*.

