ok guys heres a tricky one, well for me any way
ok i have this drop down box which shows a list depending on a previous selection, i can't get it to work
all i get is a blank drop down... have a look and c what u think
while($alignrow = $DB->fetch_row($aligns)) {
$racearrayvals = "";
$races = $DB->query("SELECT * FROM ibf_rpg_race WHERE alignmentid='".$alignrow['id']."' ORDER BY raceid");
$count = 0;
while ($row = $DB->fetch_row($races)) {
if ($user['rpgrace'] == $row['raceid'] AND $user['alignment'] == $row['alignmentid']) {
$raceoptions .= "<option value=\"{$row['raceid']}\" SELECTED>{$row['name']}</option>\n";
} elseif ($user['alignment'] == $alignrow['id']) {
$raceoptions .= "<option value=\"{$row['raceid']}\">{$row['name']}</option>\n";
}
if($count > 0) {
$racearrayvals .= ",'".$row['name']."','".$row['raceid']."'";
} else {
$racearrayvals .= "'".$row['name']."','".$row['raceid']."'";
}
$count++;
}