[davidw]

Ok, two more questions...
(I was gonna start on this next week but decided to start earlier).

1. How do I pull the title from the forumid? (eg. the forum's title) -
2. How do I pull the post from the threadid?

Here's my work in progress...

PHP Code:

<?php

        $forumid1=73;
        $desclimit1=3;
        $titlelen1=22;
        
//        $forumid2=53;
//        $desclimit2=3;
//        $titlelen1=22;

//        $forumid3=67;
//        $desclimit3=3;
//        $titlelen3=22;

//        $forumid4=71;
//        $desclimit4=3;
//        $titlelen4=22;

//        $forumid5=66;
//        $desclimit5=3;
//        $titlelen5=22;

//        $forumid6=69;
//        $desclimit6=3;
//        $titlelen6=22;

//        $forumid7=68;
//        $desclimit7=3;
//        $titlelen7=22;

//        $forumid8=70;
//        $desclimit8=3;
//        $titlelen8=22;

//        $forumid9=;
//        $desclimit9=3;
//        $titlelen9=22;

//        $forumid10=;
//        $desclimit10=3;
//        $titlelen10=22;

$news1=mysql_query("
        SELECT *
        FROM ".TABLE_PREFIX."thread
        WHERE forumid='$forumid1'
        ORDER BY dateline
        DESC LIMIT='$desclimit1'
        ") or die(mysql_error());

// Return title, replycount, postusername, last poster, views, date

$newstitle1            =    $news1['title'];
$newsdate1            =    $news1['date'];
$newstime1            =    $news1['time'];
$newsreplycount1    =    $news1['replycount'];
$newsviews1            =    $news1['views'];
$newspostusername1    =    $news1['postusername'];
$newslastposter1    =    $news1['lastposter'];
$newspost1            =    $news1['post'];

// Create link to full article

while ( $row = mysql_fetch_array ( $news1 ) ) 
    {
        ?><table align="center">
            <tr>
                <td align="left" width="550"><?php print $newstitle1; ?></td>
                <td align="right" width="80"><?php print $newsdate1; ?><br /></td>
                <td align="right" width="70"><?php print $newstime1; ?><br /></td>
            </tr>
            <tr>
                <td colspan="3" align="left"><?php print $newspost1; ?></td>
            </tr>
            <tr>
                <td align="left" width="300">Last Posted By:<?php print $newslastposter1; ?></td>
                <td align="right" width="200">Views:<?php print $newsviews1; ?><br /></td>
                <td align="right" width="200">Replies:<?php print $newsreplycount1; ?><br /></td>
            </tr>
        </table><?php
    } 

?>