Chris, Try this: http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html On 20 June 2011 20:56, Chris Stinemetz <chrisstinemetz@xxxxxxxxx> wrote: > I have the bellow sql query. What is the correct way to add ORDER BY > posts.post_date DESC > > I would like to add it to the end of my query, but I am just getting a > blank page or my added "query doesn't work" echo: > > "The posts could not be displayed, please try again later." > > The query is: > > //fetch the posts from the database > $posts_sql = "SELECT > posts.post_store, > posts.post_content, > posts.post_date, > posts.post_by, > users.user_id, > users.user_name > FROM > posts > LEFT JOIN > users > ON > posts.post_by = > users.user_id > WHERE > posts.post_store = " . > mysql_real_escape_string($_GET['id']); > > > > Thank you in advance for your help. > > Chris > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Best regards, Gavin C
