Help with checkboxes...

[gunhoe86]

I have three seperate messages in a MySQL database, and when the user selects one or more of them from a list of checkboxes, i want my script to email the message(s) to the user per the checkboxes he/she selected. i obviously have some big problems here, any help would be greatly appreciated.

$query1="SELECT message1 FROM checkboxes";
$result1 = mysql_query($query1)
or die ("<p>error mysqlQuery1");

$from = "From: Name <[e-mail]>\r\n";

if ( $checkstuff1 == ""

//i dont know what condition goes here to signify
//whether or not the checkbox was selected or not

{
mail("$email","Requested Information","$result1","$from");
}

copy the above for message2 and message3

thanks, josh

[zhabala]

When checkboxes are checked they are transfered (send) when the form is sent. And the variables are filled with value "on". When they are not checked the variables are empty and are not set. So you can use this conditional statement

if ( isset($checkbox1) and !empty($checkbox1) ) {
// the checkbox1 was checked
}

Zdenek

[gunhoe86]

alright, thanks, that helps alot.

i have one more question, when this code is executed with checkstuff1 checked, the text "resource id #3" shows up, which is not what's in the db.

$query1="SELECT message1 FROM checkboxes";
$result1 = mysql_query($query1)
or die ("<p>error mysqlQuery1");

if ( isset($checkstuff1) and !empty($checkstuff1) )
{
echo("$result1");
}

any ideas?

~JOSH

[zhabala]

$result is so called pointer to the result which is returned by database. When you want to go through the result you have to fetch rows from it like:

while ( $row = mysql_fetch_assoc($result)) {
// $row is then an array containg all fields from your select statement
// so you can echo them or for debugging purposes you can print_r them

print_r ($row);

}

checkstuff1 should be the name of the checkbox in your HTML formular.

Zdenek

[gunhoe86]

OK, so here's my code now. When it is processed, the word

"Array" is echoed, and that's it.

$query1="SELECT message1 FROM checkboxes";
$result1 = mysql_query($query1)
or die ("<p>error mysqlQuery1");

if ( isset($checkstuff1) and !empty($checkstuff1) )
{
while ( $row1 = mysql_fetch_assoc($result1))
{
echo ($row1);
}
}

any ideas?

~JOSH

[zhabala]

It seems that you don't know what you can do with arrays.

You can display one value by echo $array['field'];
In your case probably echo $row['message1'];

You can print out whole array by print_r ($array);

You can go through the array and prind each element:

foreach ( $array as $key => $value ) {
    echo $key.' = '.$value.' <BR>\n';
}

It depends on what you want the script to do

Zdenek

[gunhoe86]

Oh OK, I didn't see that it put it all into an array. Thank you very much, the program works now. This forum is great. 😃

~JOSH