Display thread text on home page?

[CrimsonGT]

I have a script that allows me to post the last 3 thread titles and who created the thread from a specific forum. I am using this to create a news script, so I can post news to a forum and then have it display on the home page under news. My only problem is this... (here is the script)



// Connecting to your database



mysql_connect($db_host, $db_user, $db_pw)



OR die ("Cannot connect to your database");



mysql_select_db($db_name) OR die("Cannot connect to your database");



// Below is the beginning of a table. If you feel you don't need it, you may remove it.



echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"4\"><tr><td>";



$tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");



while($tget=mysql_fetch_array($tsql))



{



$lastpost = $tget['lastpost'];



$title = $tget['title'];



$tid = $tget['threadid'];



$poster = $tget['postusername'];



$psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid ASC");



$getp=mysql_fetch_array($psql);



$pid = $getp['postid'];



$date2 = date ("m/d/y h:i A" ,$lastpost);



$title = substr($title,0,$txtlimit);



echo "<font size=\"2\" face=\"$fontface\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\"><FONT SIZE=\"2\" COLOR=\"$titlecolor\" face=\"$fontface\">$title</FONT></a></font><br /><font color=\"$postedcolor\" face=\"$fontface\" size='1'>posted by $poster on <i>$date2</i></FONT><br />";



}



echo "</td></tr></table>";



?>



Heres what it shows as of right now...
http://www.nightmaremotorsports.com/news.php

Edit -

Well I figured out that I actually need to pull the data from the table "post" field "pagetext" but I dont know enough PHP/MySQL to code it so that it pulls that out and displays it as well. Can someone help me with this?

[Marco van Herwaarden]

The column lastpost is only to indicate the timestamp the last post in that thread was mad.

To get the text of the last post you will have to use the pagetext column in the post table.

PS A thread don't contain any posttext, only a title and some more info. All text is in the post table.

[CrimsonGT]

Thanks, you posted that right as I figured it out a few minutes ago lol. I am having a problem though with figuring out how to code it properly to pull the posttext out of "post" and put it in a variable. Its driving me nuts