What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MySQL query

MySQL query
Author: Message:
NiteMare
Veteran Member
*****

Avatar
Giga-Byte me

Posts: 2497
Reputation: 37
37 / Male / Flag
Joined: Aug 2003
O.P. MySQL query
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)
[Image: sig/]
I'll never forget what she said 6866 days, 5 hours, 6 minutes, 25 seconds ago
Need hosting? Check
out my website. we can help you out :)
11-12-2007 03:38 AM
Profile PM Web Find Quote Report
WDZ
Former Admin
*****

Avatar

Posts: 7106
Reputation: 107
– / Male / Flag
Joined: Mar 2002
RE: MySQL query
Change 'mode' and 'zone' to `mode` and `zone` :p
11-12-2007 03:49 AM
Profile PM Web Find Quote Report
NiteMare
Veteran Member
*****

Avatar
Giga-Byte me

Posts: 2497
Reputation: 37
37 / Male / Flag
Joined: Aug 2003
O.P. RE: MySQL query
quote:
Originally posted by WDZ
Change 'mode' and 'zone' to `mode` and `zone` :p
how could i have missed that!:P

thanks
[Image: sig/]
I'll never forget what she said 6866 days, 5 hours, 6 minutes, 25 seconds ago
Need hosting? Check
out my website. we can help you out :)
11-12-2007 03:55 AM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On