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 startdate asc where (

{$now} BETWEEN startdate AND enddate) and categoryid = 1 limit 0,3"; This one just doesn't work, can you tell me what I have done wrong?? Thanks