WordPress.org

Support

Support » How-To and Troubleshooting » MySQL 5.0.45 DESC does not reverse my posts ASC does

MySQL 5.0.45 DESC does not reverse my posts ASC does

  • Okay so apparently when I use do this on my localhost with the exact same mysql version I get the correct ordering:
    SELECT ID, post_title FROM sg_wp_posts WHERE post_type = ‘post’ ORDER BY post_date DESC LIMIT 10;

    I will get
    * My third post
    * My second post
    * My first post

    but when I do the same sql query on MySQL on my ubuntu vps I get this:
    * My first post
    * My second post
    * My third post

    Now if I change DESC to ASC then it works on my slice in that it shows the newest post first yet it does the opposite on my local machine.

    For some reason it’s reversing the operation of DESC on my vps host. Anyone else see this happening?

    Also where is the query that is used on the front page to show the posts. I am having a hard time finding it.

  • The topic ‘MySQL 5.0.45 DESC does not reverse my posts ASC does’ is closed to new replies.