Re: ORDER BY DESC

[Chris Stinemetz <chrisstinemetz@xxxxxxxxx>]

On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
> Try..
>
> $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
> osts.post_by = users.user_id WHERE posts.post_store = "
> .mysql_real_escape_string($_GET['id'])." ORDER BY posts.post_date DESC";
>

Got it working thanks everyone who responded.

Working query:

			$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']) . "
					ORDER BY
						posts.post_date DESC ";

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php