Your select is only selecting the field 'root' but then you're trying to get
the field 'username' in your while loop. So, you can add username to your
select (or change it to *):
select root, username from training
select * from training
Regards,
Bruce
>>> Scott <[EMAIL PROTECTED]> 11/03/2
close
$query = mysql_query("SELECT root FROM training");
echo "";
if($mysql_num_rows($result)>0){
while ($r = mysql_fetch_array($query))
{
$user = $r["username"];
echo "$user";
}
}
echo "";
should load the data in the select.
To link select boxes, first you need to decide on a method:
1. ajax
