Plz help

[Carnage540]

Hello guy..i want to include a latest forum post thing on my main page of my website. is there a hack or a way to do it. thanks.

it would look like this

Latest forum post
>> Hey guys
>> Welcome to the forum
>> Another forum post

and if it could limit character so if the subject is long it goes:

>> Hey guy wh...

etc.

Thanks!!

[mr e]

$posttext = $DB_site->query_first('SELECT text FROM post ORDER BY dateline');

if (strlen($posttext) > NUMBER) {
$posttext = substr($posttext, -3);
$posttext .= '...';
}


sorry, it's late so this is a general idea of what to do :)

[Carnage540]

I don't get it. is there any site i can just download a .php file to include. or a code...i don't think that works on the main page.

I want to do it like your site ( i think it your site)


http://www.sitetutor.net/

The " Latest Threads " on the right...

[mr e]

i help out the guy who owns it, but is this more what your looking for? just put this inside any php file where you want the text to go


$getthreads = $DB_site->query('SELECT threadid, title, lastposter, lastpost FROM thread ORDER BY dateline DESC LIMIT 10');
print '<table>';

while($threads = $DB_site->fetch_array($getthreads)) {
print '<tr><td><a href="FORUMURL/showthread.php?s='.$session['sessionhash'].'&goto=newpost&threadid='.$threads['threadid'].'">'.$threads['title'].'</a><br />';
print 'Last Post by: '.$threads['lastposter'].'<br />';
print 'Posted on: '.vbdate($dateformat, $threads['lastpost']).'</td></tr>';
}
print '</table>';