09-05-2004, 05:18 AM
you can do it with php, just query for the first/last post (whichever you want), cut the post down to a few sentences, and put it in the TITLE of the link to the thread . . .
pseudo-code
$selectPost = mysql_query("SELECT * FROM posts ORDER BY postdate DESC LIMIT 1");
# you can use DESC for the first post, not entirely sure of phpBB or whatever's table name and postdate name, but it's got one.
$postData = mysql_fetch_array($selectPost);
# put the stuff into an array
$postMessage = $postData['message'];
#get the post's content, you can do something here to chop it up, limit the amount of characters to 100 or something.
and where it's linked from the forum --
<A HREF="viewpost.php" TITLE="<?=$postMessage; ?>This Post Title</A>
and that will give you a tooltip with the post's first/last message
pseudo-code
$selectPost = mysql_query("SELECT * FROM posts ORDER BY postdate DESC LIMIT 1");
# you can use DESC for the first post, not entirely sure of phpBB or whatever's table name and postdate name, but it's got one.
$postData = mysql_fetch_array($selectPost);
# put the stuff into an array
$postMessage = $postData['message'];
#get the post's content, you can do something here to chop it up, limit the amount of characters to 100 or something.
and where it's linked from the forum --
<A HREF="viewpost.php" TITLE="<?=$postMessage; ?>This Post Title</A>
and that will give you a tooltip with the post's first/last message
ammit potato!