select statement

[Anon]

Hello,

I don't understand this. I have this statement:

$sql="SELECT status.studentID, student.student_fname
FROM status
LEFT JOIN student ON status.studentID=student.studentID
WHERE status.schoolID='$schoolID'
AND currentStatus='Yes'";

And this gives me an error. I just don't understand what is wrong. Can anyone see it??

Thanks for your time.

[Anon]

Thanks everyone but I got it. 🙂