I just put together a select from the database, here is what it looks like:
PHP Code:
$result = mysql_query("SELECT * FROM vb3_thread WHERE forumid != 23 ORDER BY lastpost DESC LIMIT 0,10");
while($r=mysql_fetch_array($result)){
$threadid=$r["threadid"];
$title=$r["title"];
$postusername=$r["postusername"];
$forumid=$r["forumid"];
$replycount=$r["replycount"];
$posterid=$r["postuserid"];
$views=$r["views"];
?>
<tr align="middle">
<td class="alt2" align="left"><a href="http://www.example.com/forums/showthread.php?t=<? echo $threadid; ?>"><? echo $title; ?></a></td>
<td class="alt1Active" id="f44" align="center"><? echo $replycount; ?></td>
<td class="alt2" noWrap width="32"><? echo $views; ?></td>
<td class="alt1"><a href="http://www.example.com/forums/member.php?u=<? echo $posterid ?>"><? echo $postusername; ?></a></td>
</tr>
<?
}
?>
The problem is, it takes about 3-4 seconds to load those 10 posts, when its faster to load the whole vb website...
Any suggestions?
Steve