SQL select iz 3 tablice...

[Platypus]

$sql = "SELECT t.topic_id, t.topic_title, p.poster_id, p.post_time
FROM phpbb_topics t, phpbb_posts p
WHERE t.topic_last_post_id=p.post_id
ORDER BY topic_last_post_id DESC
LIMIT 0, 5";

jos bih trebao da mi selektira "username" iz "phpbb_users" gdje je "user_id" jednak "p.poster_id"

[zytzagoo]

Najjednostavnije:

Code:

SELECT t.topic_id, t.topic_title, p.poster_id, p.post_time, u.username FROM phpbb_topics t, phpbb_posts p, phpbb_users u WHERE t.topic_last_post_id=p.post_id AND p.poster_id = u.user_id ORDER BY topic_last_post_id DESC LIMIT 0, 5;

[Platypus]

Hvala

Stvarno ne znam sto sam ja radio, ali mislio sam da mi to ne radi... Uglavnom, sve radi sada..