Badges not displaying

[Detox]

Hey DevBest,

I'm having issue with the badges not being display on the home page

Images:

Code:

<?php
$badges = mysql_query("SELECT * FROM user_badges WHERE user_id = '".$_SESSION['user']['id']."' ORDER BY id DESC");
if(mysql_num_rows($badges) < 7) {
echo 'You have no badges';
}
while($badge = mysql_fetch_assoc($badges)) {
echo '<div class="hastip badge" title="'.$badge['badge_id'].'">
<img class="hastip" src="images/'.$badge['badge_id'].'.gif" title="'.$badge['badge_id'].'"/>
 </div>';
}
?>

 

[Markshall]

You're limiting it to 7 badges. So if the user has less than 7 badges it'll display 'You have no badges.' From your database picture I can only see 1 badge? Either add more badges or remove the limitation.

Ps: why are you using mysql_*