<?php
$base="vb35"; 
$user="root"; 
$pass=""; 
$host="localhost"; 
$link = mysql_connect($host,$user,$pass)or die("Не могу соединиться"); 
mysql_select_db($base, $link) or die ("Не могу выбрать базу"); 
$query = " 
SELECT 
    threadid, 
    lastposter, 
    title, 
    T.lastpost as lastpostdate, 
    replycount, 
    U.userid as userid 
FROM 
    vb_thread T 
    LEFT JOIN 
    vb_user U ON (T.lastposter = U.username) 
WHERE 
    T.forumid <> 26

ORDER BY T.lastpost DESC 
LIMIT 5"; 
$result = mysql_query($query, $link); 

echo mysql_error(); 

while ($row = mysql_fetch_array($result)) 
{ 
echo "<br><br>тема:  <a href='forum/showthread.php?goto=lastpost&t=".$row['threadid']."'>".$row['title']." [{$row['replycount']}]</a>"; 
if ($row['userid']) 
    echo "<br>автор:  <a href='forum/member.php?action=getinfo&userid=".$row['userid']."'>".$row['lastposter']."</a>"; 
else 
    echo "<br>автор:  {$row['lastposter']}"; 

echo "<br>дата:  ".date("d.m.y, H:i",$row['lastpostdate']);

} 
?>