Wordpress Question - GoFuckYourself.com

Cyrano · 01-12-2007, 12:47 PM

Does anyone know how to sort post categories by ID, rather than name?

the alchemist · 01-12-2007, 12:49 PM

In "wp-admin/admin-functions.php" at line 590, change:

$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_name");

to

$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_ID");

Save. Voila!

Cyrano · 01-12-2007, 12:53 PM

Quote:

Originally Posted by the alchemist

In "wp-admin/admin-functions.php" at line 590, change:

$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_name");

to

$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_ID");

Save. Voila!

No such luck, that modification alters sorting in the administration panel, not the website itself.

I'm using Wordpress 2.0.6 by the way.

Cyrano · 01-12-2007, 01:01 PM

bump for answers

the alchemist · 01-12-2007, 01:03 PM

Oh lol... Well that's easy just change it in the sidebar.php or wherever the categories are...

$sort_column = 'ID' instead of $sort_column = 'name'

Cyrano · 01-12-2007, 01:10 PM

Quote:

Originally Posted by the alchemist

Oh lol... Well that's easy just change it in the sidebar.php or wherever the categories are...

$sort_column = 'ID' instead of $sort_column = 'name'

lol... That was rather simple, thanks for the help.

the alchemist · 01-12-2007, 01:12 PM

Quote:

Originally Posted by Cyrano

lol... That was rather simple, thanks for the help.

You're welcome

01-12-2007, 12:47 PM	#1
Cyrano Confirmed User Join Date: Apr 2006 Location: USA Posts: 900	Wordpress Question Does anyone know how to sort post categories by ID, rather than name?

01-12-2007, 12:49 PM	#2
the alchemist Confirmed User Industry Role: Join Date: Dec 2004 Location: Montreal, Canada Posts: 3,271	In "wp-admin/admin-functions.php" at line 590, change: $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_name"); to $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_ID"); Save. Voila! __________________ 264 349 400

01-12-2007, 01:03 PM	#5
the alchemist Confirmed User Industry Role: Join Date: Dec 2004 Location: Montreal, Canada Posts: 3,271	Oh lol... Well that's easy just change it in the sidebar.php or wherever the categories are... $sort_column = 'ID' instead of $sort_column = 'name' __________________ 264 349 400

01-12-2007, 01:01 PM	#4
Cyrano Confirmed User Join Date: Apr 2006 Location: USA Posts: 900	bump for answers