[RESOLVED] ORDER BY problem

[stubarny]

Hi everyone,

The code below returns the set of data that I expect BUT the resulting array is back-to-front! (i.e. element 0 has the lowest post_timestamp and element 1 has the highest post_timestamp value). If I change DESC to ASC then the set of data that I'm dealing with is incorrect.

If you have any ideas I'd be very grateful as i've hit a dead end with this! :-)

Kind regards,

Stu

$sql = "SELECT title, body, post_timestamp FROM ads_live WHERE MATCH(title, body) AGAINST ('$_GET[q]' IN BOOLEAN MODE) ORDER BY post_timestamp DESC LIMIT 1,2";

$result = mysql_query($sql);

[Sxooter]

select * from (
SELECT title, body, post_timestamp FROM ads_live WHERE MATCH(title, body) AGAINST ('$_GET[q]' IN BOOLEAN MODE) ORDER BY post_timestamp DESC LIMIT 1,2) as a order by a.a.post_timestamp ASC

[stubarny]

Thanks a lot, exactly the result I was looking for.

Stu