Fetch forum subject lines for homepage

[Anon]

Does anyone know how to fetch the "subject line" from a new message posted on a Forum page and have it reproduce on a different page, say a homepage?

This is similar to this site where our messages from these forums are reproduced on the PHPBuilder homepage.

Cheers
Stephen

[Anon]

you can try to use
1) session_start();
session register("sjline");
$sjline= "some kind of subject line";
2) cookies
have forgotten code and laizy to search the manual
🙁
3) or hidden vars
echo "<input type='hidden' name='sjline' value='some kind of subject line'>";

hope helped you out

[andreas]

I asume your using an SQL database for the forum..

If you got a date field in the table where the posts are you can do something like

SELECT subject FROM forum_posts ORDER BY date DESC LIMIT 0, 10;

This will select 10 most recent post...

you can also throw in a "WHERE parent = 0" or whatever spesifies that this is not a reply to another message

Andreas