Re: [PHP] query not working properly

2007-07-26 Thread Richard Davey
Hi Joey, Thursday, July 26, 2007, 1:36:37 PM, you wrote: Hi everyone, I'mt trying to do the below query which itself works correctly, but when I add a order by statement just bombs. $query = select * from articles where ( {$now} BETWEEN startdate AND enddate) and categoryid = 1

[PHP] query not working properly

2007-07-26 Thread Joey B
Hi everyone, I'mt trying to do the below query which itself works correctly, but when I add a order by statement just bombs. $query = select * from articles where ( {$now} BETWEEN startdate AND enddate) and categoryid = 1 limit 0,3; $query = select * from articles order by