Hi guys,
i am working for add the avatar near the pseudo in shoutbox but i am a noob with SQL..
Please anyone can help me?
PHP Code:
mysql_query("SELECT avatar FROM `users` WHERE id = $row[avatar] ");
echo '</td><td style="font-size: 12px; padding-left: 5px"><img src= '.$row['avatar'].'> <a href="'.$site_config['SITEURL'].'/account-details.php?id='.$row['userid'].'" target="_parent"><b>' .$user. ':</b></a> '.nl2br(format_comment($row['message']));
echo '</td></tr>';
is my best way be it don't works