Hi, i am fairly new round here, and just wondered if anyone could help me.

I would like to display 8 select drop down menus. Each one of these has 8 choices, which are taken from a database. I am having some problems displaying them all though.

So far I have:

PHP Code:
<?
for($a=0;$a<8;$a++){
?>
<select size="1" name="blah">
<?
for($i=0;$row=mysql_fetch_row($SQL);$i++){
?>
<option><?echo "$row[0]";?></option>
<?
}
?>
<option selected>NONE</option>
</select>
<?
}
?>
This displays 8 select boxes, but only the first one has all the choices taken from the database, the others just have 'NONE'.

Any help would be greatly appreciated

Thanks.