Page 1 of 1
Sort results by date
Posted: 2012-12-20 23:41
by 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.
Re: Sort results by date
Posted: 2012-12-21 00:15
by 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
Re: Sort results by date
Posted: 2012-12-31 12:31
by 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.