Zkus to takhle:
$result = mysql_query("SELECT `bgcolor` FROM `uzivatele` WHERE `jmeno` = '$jmeno'");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf ("ID: %s Barva: %s", $row["id"], $row["bgcolor"]);
}