<?php

$sql = "SELECT * FROM users_badges WHERE user_id = 1";
$result = $dbconfig->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<img src='badges/".$row["badge_code"].".gif'>";
    }
} else {
    echo "0 results";
}
$dbconfig->close();
?>