Log in

View Full Version : SQL null (?)



d-machine
09-24-2008, 08:48 AM
Hi

How can I write this statement correctly?

SELECT * FROM marks WHERE grade={$id} AND teacher=null

my problem is with the part: teacher=null

Thank you

Nile
09-25-2008, 02:35 AM
SELECT * FROM marks WHERE grade={$id} AND teacher=NULL