Pull Title and Content From Thread

[GuruXL]

ok i need a simple hack, it simply pull the latest thread from a forum and displays it on a page. Nothing more nothing less.

vB does it all the time when it shows a thread so, I am sure you can come up with something as simple.

For examples just look at the main page of vb.org

Thanks.

[g-force2k2]

try using the getthreadinfo() function...

then call the title and user by

$threadinfo[username]
$threadinfo[title]

regards...

g-force2k2

[GuruXL]

Thanks, I will try that and post my results :devious:

[GuruXL]

I am thinking somewhere more along the lines of:

$query="SELECT * FROM $tblname ORDER BY un_date DESC LIMIT 0,$limit";
$result=mysql_query($query);
$number=mysql_numrows($result);
if($number==0){echo "No News Results"; exit();}

$i = 0;

while ($i < $number){

$nheadline = mysql_result($result,$i,"news_headline");
$nstory = mysql_result($result,$i,"news_text");
$ndate = mysql_result($result,$i,"news_date");

$headline = stripslashes($nheadline);
$story = stripslashes($nstory);


I think I can get it perfect, just needa work on it :p

EDIT: Then to view it, I could do this:


$i++;
}

showcopy();

[GuruXL]

can someone please help me implement this?