|
select more than one table -
09-23-2011, 07:11 PM
Hello everyone! I am calling data from two different tables this way:
$sql = "SELECT
topics.topic_id,
topics.topic_subject,
topics.topic_date,
topics.topic_by,
posts.post_topic,
posts.post_content,
posts.post_img
FROM
topics
LEFT JOIN
posts
ON
posts.post_topic = topics.topic_id
ORDER BY
topics.topic_id DESC";
But for some weird reason I am not getting anything from the table posts. No errors in the mysql_query either :-/ Any ideas??
|