[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

Re: [PHP-DB] ORDER BY DESC

[Gavin Chalkley]

Chris,

Try this:

http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

On 20 June 2011 20:56, Chris Stinemetz chrisstinem...@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

Re: [PHP-DB] ORDER BY DESC

[Karl DeSaulniers]

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;


Karl DeSaulniers
Design Drumm
http://designdrumm.com


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

Re: [PHP-DB] ORDER BY DESC

[Chris Stinemetz]

On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers k...@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 ;

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