Re: ORDER BY DESC
| From: | Chris Stinemetz | Date: | Mon, 20 Jun 2011 20:53:00 +0000 |
| Subject: | Re: ORDER BY DESC | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47863@lists.php.net to get a copy of this message | ||
On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers <karl@designdrumm.com> 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 ";