[PHP-DB] ORDER BY DESC

[Chris Stinemetz]

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