Sort results by date

[mikeyd8]

Anyone have any idea how to have the results sort by date descending? I have a date field in the table being searched. I have applied the tips in this article http://www.interaktonline.info/article/ ... earch.html so that I have the date displayed in the page.

[Fred]

Just add the sort to the query.
Pretty sure it will work

Code: Select all

SELECT * FROM articles WHERE a_id = '$value' ORDER BY post_date DESC

[Fred]

Sorry Mikey I was talking a load of rubbish.

You can not sort the result as it is calculated based on the priority you set to the different tables and a load of other things as well.