WordPress.org

1. davidjackson
   Member
   Posted 6 years ago #

   I would like to have the post ORDERED BY catagory(ID),post(ID) when they on displayed on the index page?

   Which PHP file is the SQL statement in?

   tia,
   david

2. skeltoac
   Member
   Posted 6 years ago #

   You don't have to edit core files to accomplish this. You can customize the query right in your template.

   Study http://codex.wordpress.org/The_Loop and wp-db.php to understand the WP_Query class.

3. davidjackson
   Member
   Posted 6 years ago #

   sketloac --
   Thanks for you reply, but you'll have to excuse me a more-or-less just a ol' database hacker, not a php progammer...

   I've looked in template-functions-catatory.php and and it looks like catagory id is used as sort order, when displaying posts?

   About line# 265:

   if (intval($categories)==0){
   $sort_column = 'cat_'.$sort_column;

   $query = "
   SELECT cat_ID, cat_name, category_nicename, category_description, category_parent
   FROM $wpdb->categories
   WHERE cat_ID > 0 $exclusions
   ORDER BY $sort_column $sort_order";

   $categories = $wpdb->get_results($query);
   }

4. Dylan Kuhn
   Member
   Posted 6 years ago #

   I should probably try it before piping up, but what if you followed the example here

   http://codex.wordpress.org/Alphabetizing_Posts

   but with &orderby=cat_ID,postID ?

Topic Closed

This topic has been closed to new replies.