Insert data in mysql

[pirri]

Hello,

I have a form with a checkbox:

<input name="Conformidad" type="checkbox" id="Conformidad" value="si">

When I insert the form data in MySql with PHP, always see in the field "Conformidad" of the table the valor N.

I want that if the checkbox is checked the field "Conformidad" = si and if the checkbox is no checked the field "Conformidad" = no.

What can I do?

[nelustr]

An example (available at: http://www.logicserv.ro/tests/0001.php ):

<?php
//  $server= ....
//  $user=....
//  $password= ...
//  $database= ...
  mysql_connect ($server, $user, $password) or die ("Can't connect!");
  mysql_select_db ($database) or die ("Can't open database $database!");
  if ($cmdAdd=="Add New"){
	   mysql_query("INSERT INTO test VALUES('','$Conformidad')");
		 }
?>
<form name="test" method="POST">
<center>
  <input name="Conformidad" type="checkbox" id="Conformidad" value="si">&nbsp;
	<input type="submit" name="cmdAdd" value="Add New">
</center>	
<table align="center" border="1">
  <tr>
   <td align="center">Id</td>
   <td align="center">Confirmadad</td>
  </tr>
<?php
	$result=mysql_query("SELECT * FROM test");
	while (list($id,$confirmadad)=mysql_fetch_array($result)){
				echo "<tr><td align=\"center\">$id</td><td align=\"center\">$confirmadad</td></tr>\n";
				}

?> 
</table>
</form>