like this for example:
$sql = "SELECT u.username, p.*, pt.post_text, pt.bbcode_uid, pt.post_subject, p.post_username
FROM phpbb_posts p, users u, phpbb_posts_text pt
WHERE p.topic_id = $topic_id
AND p.poster_id = u.user_id
AND p.post_id = pt.post_id
ORDER BY p.post_time ASC";
FROM phpbb_posts p, users u, phpbb_posts_text pt
WHERE p.topic_id = $topic_id
AND p.poster_id = u.user_id
AND p.post_id = pt.post_id
ORDER BY p.post_time ASC";
this helped me alot i wanted to learn how to do this to select multiples selections in three different tables and fields in my databases
tags: muti multiple