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
