I'm having a strange problem with a statement in my events db, I'm stumped.
"SELECT * FROM events, venues WHERE events.vid<>2 AND events.vid=venues.vid AND events.date >= CURRENT_DATE LIMIT 1"
What's wierd is that this gives an event with vid 1, and ignores a more recent event with vid 4. I've messed with the order, changed <> to (*more OR *less). No better. What's going on? Help appreciated....
"SELECT * FROM events, venues WHERE events.vid<>2 AND events.vid=venues.vid AND events.date >= CURRENT_DATE LIMIT 1"
What's wierd is that this gives an event with vid 1, and ignores a more recent event with vid 4. I've messed with the order, changed <> to (*more OR *less). No better. What's going on? Help appreciated....