How can i set the order of links after date.
I want the list of links to be sorted in date order.
Links sort by date
Moderator: pgolovko
2 posts
• Page 1 of 1
by pgolovko » 10/25/2007 7:02 pm
In./admin/functions.php on line 1146 find this:
and replace with this:
- Code: Select all
$result = mysql_query("SELECT * FROM `links` WHERE `category_id` = '".$id."' AND `visible` = '1' ORDER BY `recip` DESC, `gpr` DESC, `title` ASC LIMIT ".$from.", ".$limit."");
and replace with this:
- Code: Select all
$result = mysql_query("SELECT * FROM `links` WHERE `category_id` = '".$id."' AND `visible` = '1' ORDER BY `recip` DESC, `date` DESC, `title` ASC LIMIT ".$from.", ".$limit."");
__________________
Best regards,
Pavel Golovko
Best regards,
Pavel Golovko
-
pgolovko - Posts: 494
- Joined: 03/25/2006 1:23 am
- Location: Somewhere on planet Earth ....
2 posts
• Page 1 of 1
Return to Customization & Templates
Who is online
Users browsing this forum: No registered users and 0 guests