View Full Version : Arrange pages alphabetically?
Watson
10-12-2004, 05:36 PM
Is there anyway I can change my custom page list to be listed alphabetically by identifier, its just I have alot of files, and would be easier to read them in that way
Cheers
Watson
Ghostsuit
10-12-2004, 08:42 PM
In vba_cmps_admin.php
Find$pages = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "adv_pages"); Replace with $pages = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "adv_pages ORDER BY title");
Watson
10-13-2004, 08:01 AM
works mate but I am looking to do it not by the title but by the identifier, I tried identifier instead of title and it dont work, and idea what the code would be?
Ghostsuit
10-13-2004, 08:29 AM
Doh, my bad. :s
List by Identifier should be...
$pages = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "adv_pages ORDER BY name");
Watson
10-13-2004, 05:19 PM
Works a treat mate, cheers
Ghostsuit
10-14-2004, 12:36 AM
No problem. Glad to help. :D
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.