I was able to reproduce your form with a dummy database
that I made with the data you supplied in your code...
When doing this, I noticed that your code you supplied was
missing a right brace } you have three left braces {
and only two right braces }
also there is no value assigned to $ID so the
ID=$ID points to nothing (null) when you click on the
hyperlink of Edit.php
Ken
--- In php-objects@xxxxxxxxxxxxxxx, "perfectsolution1" <drshea@...>
wrote:
>
> --- In php-objects@xxxxxxxxxxxxxxx, "Ken" <ken.poyser@> wrote:
> >
> > What does $List has??!!
> >
> > Ken
> >
> >
> >
> > --- In php-objects@xxxxxxxxxxxxxxx, "perfectsolution1" <drshea@>
> > wrote:
> > >
> > > Can anyone help me work this out? I have an array with a room
number
> > > associated with fname, lname, etc. I know the number of rooms,
and
> > > want to fill in the form with textbox where the room is empty,
and
> > > with the persons name in the room associated with the specific
room.
> > > This is my code I have come up with that only gives me the
table
> > once
> > > with the first person, and text boxes in the other rooms.
> > >
> > > $row=mysql_fetch_array($List);
> > > for($i=1;$i<=12;$i++){
> > >
> > > echo "<td align='center'>";
> > > if($row['room']!=$i){
> > > echo"$i</td>";
> > > echo"<td align='center'><input type='text' name='lname'></td>";
> > > echo"<td align='center'><input type='text' name='fname'></td>";
> > }
> > > else {
> > >
> > > echo "$row[room]</td>";
> > > echo "<td align='center'><a href = 'Edit.php?ID=$ID'>"
> > > .ucfirst($row[lname])." </a></td>";
> > > echo "<td align='center'><a
> > > href='Edit.php?ID=$ID'>".ucfirst($row[fname])."</a> </td>";
> > > }
> > >
> >
> Thank you for responding. My query is:
> $query_List = "SELECT room, lname, fname FROM info ORDER BY room";
> $List = mysql_query($query_List, $pmAdmin) or die(mysql_error());
>
