Re: [PHP] query not working properly

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 =

[PHP] query not working properly

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 st