forum last topic..

[syncbyte]

hi guyz..

how can i make phpbb forum last topic?? or smf last topic?
i tried to make but its not working..:/

thx

[gorda001]

I don't really understand. You want to create a new topic in phpbb/smf? Or do you want to get the name of the last topic?

[Damien Gray]

I think he means he wants to create a link to the last topic posted.

This is what I'd do (someone always has a better answer than me >_>)

 $sql = "SELECT * FROM `topics` ORDER BY `id` DESC, LIMIT 1";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

echo '<a href="topic.php?id="'. $row['id'] .'">'.$row['topic_title'].'</a>'; 
  

Untested, but with the right field names, it should work.

[bfsog]

While your code looks good to go Damien, there is no point returning all columns (*) when you only need two of them. Replace the * with id and topic_title (or whatever the correct column names are).

Edit: And also be sure to check the $result returns some data (at least 1 row).

[gorda001]

Also you should be doing htmlspecialchars on topic_title.