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,
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;
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 =
