ultimele anunturi adaugate

[MariuSache]

salut

Vreau sa-mi apara din baza de date ultimele 5 (10) anunturi adaugate, am cautat si am gasit pt phpbb. Am incercat sa modific aici:

$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
WHERE t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
ORDER BY p.post_id DESC LIMIT 5";

dar nu am reusit.. plss.. help me. MS :x

Incearca asta:

$interogare = "SELECT titlu,id FROM bd ORDER BY id DESC LIMIT 0,5"; 
$rezultat = mysql_query($interogare) OR die ("Nu se poate executa interogarea!"); 
while ($rand = mysql_fetch_array($rezultat, MYSQL_BOTH)) { 
// blablabla
}

Sunt afisate ultimele 5 mesaje.

[Luxian]

Gasesti aici ultimele topicuri active.