View Single Post
(#1 (permalink))
Old
cbarg cbarg is offline
Member
cbarg is on a distinguished road
 
Posts: 54
Join Date: Sep 2011
Default 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??
Reply With Quote
Sponsored Links