how to fetch images from images table and display along with topic?

[lovephp]

ok so i got one table as topic and one is images now im trying to display the topic which is displaying ok but how do i get the images matching the topic id?

 

the image table has rows like

id tid img_name  

$stmt = $db->prepare("SELECT * FROM topic");
$stmt->execute();
$rs = $stmt->fetchAll();
foreach( $rs as $trs ) {
echo $trs['topic_name'];
}

                            
                          

Edited March 19, 2016 by lovephp

[Barand]

SELECT topic_name
, image_name
FROM topic t
LEFT JOIN image i ON i.tid = t.id

I used LEFT join in case some topics have no image. If all topics have an image, use INNER JOIN, it's more efficient.

[lovephp]

thanks bro works