Sort results by date
Sort results by date
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.
Re: Sort results by date
Just add the sort to the query.
Pretty sure it will work
Pretty sure it will work
Code: Select all
SELECT * FROM articles WHERE a_id = '$value' ORDER BY post_date DESC
Re: Sort results by date
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.
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.