Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
Thread: problem with select where
02-23-2014, 04:45 AM #1
problem with select where
Any idea why my query is returning the article where priority is set to zero
when query is to select articles with priority greater than zero?
Without the AND clause it works, but I need the AND clause so I can't remove it.
myDatabase setting for 'priority' col
smallint(11) //values possible from form 0-9
test field values in database:
News test test 0
myQuery in php page:
$result = $mysqli->query("SELECT `headline`,`title`,`article`,`priority`
WHERE (`priority` > 0)
AND (`title` IS NOT NULL) OR (`article` IS NOT NULL)
Priority: 0 <--this article should not be selected
I also tried WHERE (priority >= 1)
which also didn't work
02-23-2014, 05:00 AM #2
- Join Date
- Oct 2006
- Denver, Colorado USA
- Thanked 465 Times in 454 Posts
The query is matching everything with (`article` IS NOT NULL) being true. or'ing values will return a true if one or both of the values is true - false OR true = true.
use this logic -
WHERE (`priority` > 0) AND ((`title` IS NOT NULL) OR (`article` IS NOT NULL))Finding out HOW to do something is called research, i.e. keep searching until you find the answer. After you attempt to do something and cannot solve a problem with it yourself, would be when you ask others for help.
Users who have thanked CFMaBiSmAd for this post:
low tech (02-25-2014)
02-24-2014, 01:13 AM #3
Ah that looks good. I'll give that a try and post back.
I'd add a 'thanks' , but I can't see where to add that on the new forum.
Last edited by low tech; 02-24-2014 at 01:29 AM.0000
02-24-2014, 01:58 AM #4
EDIT: Found and clicked THANKS
Your code did the trick nicely.
Thanks and thanks for the explanation.
Last edited by low tech; 02-25-2014 at 05:12 AM.0000