checkbox from a database

derksj

I am very new to this so forgive me for writing terrible code
I have a table in a database that has a collum facilityID and a collum Facility
Now i want to make checkboxes from this table in a form
like this

facility1 checkbox
facility2 checkbox
facility3 checkbox
facility4 checkbox
etc.

i tried this

<?
$db = mysql_connect("intranet.hr.nl", "login", "passw");
mysql_select_db("vakantiehuizengids",$db);
$result=mysql_query("select * from tblFaciliteiten");
while ($myrow = mysql_fetch_array($result))

echo "<tr><td bgcolor=\"#5B5B5B\" align=\"left\" width=\"250\"><font color=\"#FFFFFF\"><strong>".$myrow["Faciliteit"]."</strong></font></td><td bgcolor=\"#C0C0C0\" width=\"10\"><p align=\"left\"><input type=\"checkbox\" align=\"left\" name=\"".$myrow["Faciliteit"]."\" value=\"ON\"></td><td width=\"50\"><input type=\"text\" name=\"".$myrow["Faciliteit"]."\" size=\"21\"></td></tr>\n";
?>

but now its not possible to put the data in a table
can anyone give me an example how to solve this problem

barand

There are no <table>...</table> tags in your code, at least not in that shown.

$db = mysql_connect("intranet.hr.nl", "login", "passw"); 
mysql_select_db("vakantiehuizengids",$db); 
$result=mysql_query("select * from tblFaciliteiten"); 

echo "<table>\n";

while ($myrow = mysql_fetch_array($result)) 
{
echo "<tr><td bgcolor=\"#5B5B5B\" align=\"left\" width=\"250\"><font color=\"#FFFFFF\"><strong>".
$myrow["Faciliteit"]."</strong></font></td><td bgcolor=\"#C0C0C0\" width=\"10\"><p align=\"left\"><input type=\"checkbox\" align=\"left\" name=\"".
$myrow["Faciliteit"]."\" value=\"ON\"></td><td width=\"50\"><input type=\"text\" name=\"".
$myrow["Faciliteit"]."\" size=\"21\"></td></tr>\n"; 
}

echo "</table>\n";

derksj

sorry

i mean database table