On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers 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_esc
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";
Chris,
Try this:
http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html
On 20 June 2011 20:56, Chris Stinemetz 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 gettin
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:
