checkboxes

[XiXora]

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
$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... :rolleyes: )

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 :( )