Help with checkboxes

[gunhoe86]

I want to create a form where users can select items from a list of checkboxes and when they submit the form, the data they checked is mailed to them.

i have the data to be mailed in a MySQL db, but how can I select which rows will be sent according to the checkboxes.

i'd like to use the

mail()

function to send the mail.

can anyone help, or does anyone have any better ideas?

thanks

~JOSH

[Natty_Dreadlock]

from the php doc:

if you use an array of checkboxes to submit info to a database or what have you, be careful of the case when no boxes are checked. for example:
<form method="post">
<input type="checkbox" name="checkstuff[]" value="0">
<input type="checkbox" name="checkstuff[]" value="1">
<input type="checkbox" name="checkstuff[]" value="2">
. . .
</form>
if these are submitted and none are checked, the $POST['checkstuff'] variable will not contain an empty array, but a NULL value. this bothered me when trying to implode() the values of my checkboxes to insert into a database, i got a warning saying the 2nd argument was the wrong type.

so your code could look like this:

if(is_array($_POST["checkstuff"]))
{
$queryPart = implode(",", $_POST["checkstuff"]);
$sql = "SELECT $queryPart FROM myTable;";
}
else
{
die("Nothing has been selected");
}

hth