Check Box and Arrays

[phpretard]

I have columns named -email- rookie- -coach- -minor-


R1. email has an address rookie has a value of the word "yes"
R2. email has an address coach is empty
R3. email has an address minor has a value of the word "yes"

OBJECTIVE:

When I submit the form with all three boxes check it should only send an email to rookie and minor because their values are "yes"

PLEASE HELP ME!

I know the code below doesn't work, but it's what I've been staring at with no solutions.

I have the email code working fine. I put an echo down there because if it will echo then I know I can send an email.

THANK YOU!!!!

mysql_select_db("lhbrb", $con);
 
$names = array($_POST['rookie'],$_POST['minor'],$_POST['coach']); 
 
 
 
 
$result = mysql_query("SELECT email FROM testemail WHERE $names='yes'");
 
 
while($row = mysql_fetch_array($result))
  {
  echo $row['$names'] . " " . $row['email'];
  echo "<br />";
  }
 
 
 
mysql_close();
 
 
?>
 
<form action=...php method=post>
<input type=checkbox name="cb['rookie']"></td>
<input type=checkbox name="cb['minor']"></td>
<input type=checkbox name="cb['coach']">
</form>

[pbmods]

Heya, PR. Welcome to TSDN!

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

[phpretard]

Sorry about not posting the code correctly.

[kovik]

I remember this from yesterday... Same posting name and all. :-P

I'm not sure if you remember, but I'm pretty sure we told you to build the query using the submitted checkboxes. What you are doing is literally telling SQL "WHERE Array = 'yes'." Maybe the implode() function will shed some light on what you could do instead.

[pbmods]

I remember this from yesterday... Same posting name and all. :-P]

PM me with the link to the duplicate, and I will investigate.

[erp23]

i've done something similar - the action page is quite simple.
I have set the value of the checkbox equal to the email address that I want it sent to, which is pulled from mySQL and placed in the field like this:

[PHP]echo "<input name=\"email[ ]\" type=\"checkbox \" value=\""; echo $row_rs_other['emailAddress']; echo"\" />";[/PHP]


Once you submit the checkbox values, this should work fine in the action page:
[PHP]$data = implode(", ", $_POST['email']);[/PHP]
Only the selected checkboxes have a value
Then use $data in the as the to variable in mail(....

[kovik]

PM me with the link to the duplicate, and I will investigate.

Oh! No no, not here on TSDN... Over at DevNetwork.

[kovik]

Only the selected checkboxes have a value
Then use $data in the as the to variable in mail(....

Those are the only checkboxes that are posted. If you want to have ALL of them and determine which are on or off, you need to create an array of all of the options, and then do a comparison of the posted data with the options you defined.