PHP question about checkboxes

[franwpd]

Database Table: contacts

id | name | email | c1 | c2 | c3 | notify
1 | Suzie | [e-mail] | a girl | | | Y
2 | John | [e-mail] | | a boy | | Y
3 | Uni | [e-mail] | | | none | Y

form:

Send email to this type of people:

<input type=checkbox name=c1 value="a girl">
<input type=checkbox name=c2 value="none">
<input type=checkbox name=c3 value="a boy">

PHP:

$sql = "SELECT email FROM contacts WHERE notify = 'Y' AND (checkbox is checked);

How can I specify the fields that are checked?

[slick101]

Maybe you want to give the checkbox the same name with array.

<input type=checkbox name="c[]" value="a girl">
<input type=checkbox name="c[]" value="none">
<input type=checkbox name="c[]" value="a boy">

then you can check

<?php
echo '<pre>';
echo print_r($_POST['c']);  // This will give you good example whats going on.
echo '</pre>';


foreach($_POST['c'] as $v){
   if($v == 'a boy')
      echo 'Its a boy!';
}

and you can get rid of 2 fields in your db and just check on field c on what it is. You might not even need an array if you just need 1. But what if they have a boy and a girl!?