MySQL query - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: MySQL query (/showthread.php?tid=78966)
MySQL query by NiteMare on 11-12-2007 at 03:38 AM
this is frustrating me why is this query not returning any results when it should be:
code:
SELECT * FROM ads WHERE 'mode' != 4 AND 'mode' != 3 AND 'zone' = 1
no errors it just doesn't return the results, and when i remove the 'zone = 1 it works fine(and yes i do have results that meet those three conditions)
RE: MySQL query by WDZ on 11-12-2007 at 03:49 AM
Change 'mode' and 'zone' to `mode` and `zone` 
RE: MySQL query by NiteMare on 11-12-2007 at 03:55 AM
quote:how could i have missed that!
Originally posted by WDZ
Change 'mode' and 'zone' to `mode` and `zone`
thanks