
May 14th, 2004, 03:07 PM
|
|
Contributing User
|
|
Join Date: Dec 2003
Posts: 377
Time spent in forums: 40 m
Reputation Power: 5
|
|
|
Way to make this query work
Query worked fine until recently. Now I saved and decided to re-write the query because its getting nothing.
Code:
SELECT * FROM $forumzDB.forumz_forums
WHERE
(visible = '1' AND subFID = '0' AND ".$user_properties['status_id']." >= `level` AND (type = 'publ' OR type = 'anon'))
Returns nothing.
Whereas
Code:
SELECT * FROM $forumzDB.forumz_forums
WHERE
visible = '1'
AND subFID = '0'
AND ".$user_properties['status_id']." >= `level`
AND type = 'publ' OR type = 'anon'
Returns most, but not all. It seems to return results where subFid DOESNT equal 0, when the query clearly states only where subFID = 0.
This is driving me nuts :|
|