[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?