Re: Funny order for posts in thread

Posted on 2010-01-13 23:28:48.574018-08 by szabgab in response to 12188

Apparently SQLite kept the order of the lines in the database straight so we have not noticed the lack of ORDER BY on the queries. Now that we moved to PostgreSQL this created the funny ordering.

I put an "ORDER BY id DESC" on the SELECT statement of the query now for displaying threads. This is showing the most recent post at the top. Please check.

I know in the near future I should allow each user to decide how s/he wants to see the posts and even adding a threaded view but in the meantime, should I leave it this way or should I turn it around showing the most recent post at the bottom?

Direct Responses: 12193 | Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.