[ADodb-general] How to generate a series of checkboxes ?

[<li...@tu...>]

Hi,

I have this table, called interesses.
It has a columns "interesses_name" and another, "interesses" with
several data already in.

I'd like to generate a list of checkboxes with ADodb, but can't figure
how. Yes, i've read the docs and googled.

What i've tried is:

<?php
 // select interesses names and values to build the chekboxes
 $recordSet = &$conn->Execute('SELECT interesses_name, interesses FROM
 interesses ORDER BY interesses ASC');
	
 // build the checkboxe's list
 if (!$recordSet)
  print $conn->ErrorMsg();
 else {
  while (!$recordSet->EOF) {
   print($recordSet->fields[1] . '<input name=$recordSet->fields[0]
   type=\'checkbox\' id=\'interesses\' value=\'1\'>');
   $recordSet->MoveNext();
 }
$recordSet->Close();
$conn->Close();
}
?>

I have have no error, but what is built is a series of (odd) textboxes,
not checkboxes.

Any idea how to do this ?

Thanking you in advance.

Warm regards,
Mário Gamito