Quote Originally Posted by fvb View Post
when I edit a category and change the sort order, the order changes like it should

I was hoping to change the sort order of the admin/extras/links so the new ones that need approval would come up first
open admin/links.php

find this line of code (around line 556)
PHP Code:
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by ld.links_title, l.links_url"; 
and replace with this line
PHP Code:
$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by l.links_date_added DESC, ld.links_title, l.links_url";