View Single Post
12-31-2010, 05:38 PM
Join Date: Apr 2005
Location: Kent, UK
this bit OR imageid = NULL
fails because no value can be equal to null. (it's an sql rule)
The IS NULL gets round this problem.
you can also use ifnull( table1.imageid, 0 ) AS imageID to substitute 0 (or even 'unknown') for null, which looks better to users who don't understand null.
View Public Profile
Send a private message to Dr John
Visit Dr John's homepage!
Find More Posts by Dr John