bfhruxhs

$timehour = 3600;
/*$time = unix_timestamp();*/
$busts= ("SELECT COUNT(b.bustid), b.bid,b.time,u.username,u.display_pic, u.userid FROM `busts` b LEFT JOIN `users` u ON b.bid=u.userid WHERE b.time > " .time(). " - " .$timehour. " ORDER BY b.bid limit 0,1 ") or die($db->error());
    $result = mysql_query($busts) or die(mysql_error());
//IF THERE ARE ENTRIES IN THE DB AND THIS SHOWS REMOVE THE ! FROM THE IF
     if (!$result->EOF) {
echo"Buster of the Hour: None";

}else{
// Print out result
//IF THERE ARE NO ENTRIES IN THE DB AND ITS TRYING TO SHOW THIS ADD A ! TO THE WHILE STATEMENT
while($result->EOF) {
$row = mysql_fetch_array($result)
$user=$db->query("SELECT username FROM `users` WHERE `userid` = ".$row['bid']."");
    echo "Buster of the Hour: <a href='viewuser.php?u={$row['bid']}'> {$row['username']} ID[". $row['bid'] ."] </a> <img src='{$row['display_pic']}' width='100px' height='100px' />";
    };
    }