Quote:
Originally Posted by joeroberts
PHP Code:
$bimg2 = @mysql_fetch_array(@mysql_query("SELECT avatar FROM users WHERE id=" . $row['userid']));
$avatar = $bimg2['avatar'];
if (!$avatar) {
$avatar = $site_config['SITEURL']."/images/default_avatar.gif";
}
echo '</td><td style="font-size: 12px; padding-left: 5px"><img src= '.$avatar.'> <a href="'.$site_config['SITEURL'].'/account-details.php?id='.$row['userid'].'" target="_parent"><b>' .$user. ':</b></a> '.nl2br(format_comment($row['message']));
|
really a query in a loop ? thats not really smart , also people stopped using mysql_fetch_array a long time ago - its bad for performance
hint
LEFT JOIN