ORDER BY DESC

[Chris Stinemetz <chrisstinemetz@xxxxxxxxx>]

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