Ah, my bad.
Ok, I'm going to assume that you have a field in your table to represent each checkbox item, and these fields are by default set to false, null, empty etc. And that you have been able to connect to your Database and set up your tables. If your having problems at that stage, post what errors/problems your having, and we'll see if we can help with that.
First up, check the customer and see if their email exists. If it does, update the record, else insert a new one.
Code:
//Get the
$cust_Email = $_POST['customer_Email'];
$cust_Name = $_POST['customer_Name'];
$chk_Cust = "select customer_Email from my_table where customer_Email='$cust_Email' ";
$chk_Res = mysql_query($chk_Cust);
//If the record does not exists, we have to insert it.
if(mysql_num_rows($chk_res)<=0)
{
$ins_Cust = "insert into my_table set customer_Name='$cust_Name', customer_Email='$cust_Email' ";
mysql_query($ins_Cust);
}
//Now check those boxes....
if (isset($_POST['food']) )
{
$upd_Cust = "update my_table set food='Yes' where customer_Email='$cust_email' ";
mysql_query($upd_Cust);
}
//rinse and repeat...
if (isset($_POST['clothes']) )
{
$upd_Cust = "update my_table set clothes='Yes' where customer_Email='$cust_email' ";
mysql_query($upd_Cust);
}
That's pretty basic, and you could probably use fewer SQL statements if you were clever with string concatenation when checking the boxes, but you get the idea...