adding a html checkbost to a php dynamic list

greybeard · Joined: 18 Nov 2005 Posts: 2

Hi

I am trying to create a roll.

I have a table being filled by a sql statement

What I am trying to do is put a check box in after the nemes so the student can be marked prsent or absent.

Is there a way I can get a check box in the 4th td ?
At the monet i have the the id, name and year in a table but am unable to get the checkbox on the same TR

echo '<table align="center" border="1" cellspacing="5" cellpadding="6">
<tr><td align="center"> Student_id </td>
<td align="center"> Student Name </td>
<td align="centre"> Year </td>
<td align="center"> Present </td></tr>';

// Fetch and display the records

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
echo "<tr><td align=\"center\">$row[0]</td>
<td align=\"center\">$row[1]</td>
<td align=\"center\">$row[2]</td></tr>";
}

Any assistance would be great

degsy · Joined: 23 Feb 2005 Posts: 2440 Location: North East, UK

What is the value of your present field?
Best would be to have a True/False field or in mySQL a integer using 0 and 1

In this case it is using true or false
If present = true then check the box

greybeard · Joined: 18 Nov 2005 Posts: 2

Yes it is a N or Y with N being the default.

default is 0 <absent> checked would be 1 <Present>

I will have a look and try it out.

thanks for the fast reply

Cheers
Greybeard