In message <fj7sm4+vd2j@xxxxxxxxxxx>, perfectsolution1 <drshea@xxxxxxxx>
writes
>Ken, my question is not with the query to the database but rather when
>I try to make my table from the ($rows=mysql_fetch_array($List)array,
>I cannot seem to iterate through the database and leave blank
>textboxes where the room is not associated with the row in my array,
>and only have the rooms that are associated with a person filled in.
Your original code only read the first record, and iterated through
that.
Start by changing
$row=mysql_fetch_array($List);
for($i=1;$i<=12;$i++){
to
while ($row=mysql_fetch_array($List)){
And that will iterate through the table
--
Pete Clark
Sunny Andalucia
http://hotcosta.com/Andalucia.Spain
