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 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??
Err.. ORDER BY comes at the END of your query, not the start.
SELECT * FROM blah WHERE blahblah ORDER BY y ASC LIMIT x,y
Cheers,
Rich
--
Zend Certified Engineer
http://www.corephp.co.uk
"Never trust a computer you can't throw out of a window"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
