Results 1 to 2 of 2

Thread: SQL null (?)

  1. #1
    Join Date
    Nov 2007
    Posts
    151
    Thanks
    67
    Thanked 0 Times in 0 Posts

    Default SQL null (?)

    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

  2. #2
    Join Date
    Jan 2008
    Posts
    4,168
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    Code:
    SELECT * FROM marks WHERE grade={$id} AND teacher=NULL
    Jeremy | jfein.net

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •