Re: ORDER BY DESC
| From: | Gavin Chalkley | Date: | Mon, 20 Jun 2011 20:20:02 +0000 |
| Subject: | Re: ORDER BY DESC | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47861@lists.php.net to get a copy of this message | ||
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@gmail.com> 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