checkboxes

i have no idea what to do

i'm trying to make a few check boxes that show up depending whats in my category table (categoryid(id),game(short name of the game),title(long name of the game).

i got this atm

PHP Code:

  $gamefields=$DB_site->query("SELECT *
                                  FROM gamefield
                                  WHERE editable = 1
                                  LEFT JOIN category
                                  ON gamefield.gameid=category.categoryid
                                  LEFT JOIN usergamefield
                                  ON gamefield.gameid=usergamefield.userid
                                  ORDER BY displayorder");
  while ($gamefield=$DB_site->fetch_array($gamefields)) {
    if($gamefield[??]=='1'){
    $gamefieldname="field$profilefield[profilefieldid]";
$checkbox="<input type=\"checkbox\" id=\"$gamefieldname\" checked>";
} else {
    $gamefieldname="field$profilefield[profilefieldid]";
$checkbox="<input type=\"checkbox\" id=\"$gamefieldname\">";
}
    if ($bgcolor=="#13486D") {
      $bgcolor="#1C5780";
    } else {
      $bgcolor="#13486D";
    }
    eval("\$gamefields .= \"".gettemplate("register_gamefields")."\";"); 


as you see, i was trying to make it like the custom profile fields. but its not working
plz help
i probably aint explained it enuff ( never was good at explaining... )

if u can help post here or msn me at xixora@cobraclan.co.uk, icq me at 79028021 or what ever ( cobraclan.co.uk email offline )