Astanda.com forums :: View topic - Links sort by date

Astanda.com forums Forum Index

Astanda.com forums

FAQ

Usergroups

Register

Log in to check your private messages

Links sort by date

This forum is locked: you cannot post, reply to, or edit topics.

This topic is locked: you cannot edit posts or make replies.

Astanda.com forums Forum Index -> ADP templates

View previous topic :: View next topic

Author

Message

moromete
Private

Joined: 20 Sep 2007
Posts: 14

Posted: Sun Oct 14, 2007 5:27 am Post subject: Links sort by date

How can i set the order of links after date. I want the list of links to be sorted in date order.

Send private message

admin
Site Admin

Joined: 01 Jan 1970
Posts: 582
Location: Somewhere on planet Earth ....

Posted: Fri Oct 26, 2007 3:02 am Post subject:

Reply with quote

In./admin/functions.php on line 1146 find this:

Code:

$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:

$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
---------------------------
Help me help you. I'm not a God, and can not read your mind. If you got a problem, then please describe it well.

Send private message

Send e-mail

Visit poster's website

Yahoo Messenger

Display posts from previous:

	Astanda.com forums Forum Index -> ADP templates	All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group