[RESOLVED] Storing checked checkboxes into mysql table

[adi]

Hi!
Can you guys tell me what is the best aproach to this problem?
I have a form with checkboxes like the one bellow and i want to store the checked boxes into a table like this(1 if checked, 0 if not):

Form:

Aaaa: [ x ]
Bbbb: [ ]
Cccc: [ x ]
Ddd : [ ]
Eee: [ x ]

Table:

---

id | Aaaa | Bbbb | Cccc | Dddd |Eee|

---

123| 1 | 0 | 1 | 0 | 1 |

---

My problem is how to construct the mysql query?

Thank you.

[devinemke]

for booleans i typically use a CHAR(1) field that defaults to NULL and use a "Y" for true and NULL for false. a simple example:

<?php
$checkboxes = array(
'aaa',
'bbb',
'ccc',
'ddd',
'eee'
);

if (!isset($_POST['submit']))
{
	echo '<form action="" method="POST">';

foreach ($checkboxes as $value)
{
	echo '<input type="checkbox" name="checkboxes[' . $value . ']" value="Y"> ' . $value . '<br>';
}

echo '	
<input type="submit" name="submit" value="submit">
</form>
';
}
else
{
	foreach ($checkboxes as $value)
	{
		if (isset($_POST['checkboxes'][$value])) {$sql_array[] = $value . " = 'Y'";}
		else {$sql_array[] = $value . ' = NULL';}		
	}

$sql = 'INSERT INTO table SET ' . implode(', ', $sql_array);
echo $sql;
}
?>

[adi]

Thank you, it works.🙂