Please Help!!!!

[jonn_g]

Well here's my problem. I have a mySQL table with a field called email. Now I want the PHP code to print all of its records and a checkbox for each one of these. Then it should take the field "emai" from all the checked records and place the values (e-mail adresses) into ONE string separating them with ";". Then the string will be inserted into a new table so that when read through a "mailto:" link a mass e-mail will be sent.

The problem is at the step of choosing all the checked records and inserting their field "e-mail" into a string separated with ";".

PLEASE HELP!

[sledgeweb]

OK, don't have time for the exact code, but this should get you looking in the right direction:

1) Pull all your fields from the database
2) Create a form tag
3) Cycle through all your records, output a checkbox and the email. Give each checkbox a unique name.
4) Create the form end tag at the end of your loop
5) When you submit form:
6) Cycle through form checkbox variables
7) If checkbox is on, add email plus ";" to a string.
8) Mailto string

When creating your checkboxes, use the count variable in the name.

for ($i = 0; $i < $numRows; $i++)
{
print "<input type=\"checkbox\" name=\"email{$i}" value=\"ON\">" . mysql_result($result, $i, 'email');
}

Cycling through form tags:

if ($_POST[$email{$i}] == "ON")
{
$string .= $value . ";";
}

Hope this makes sense. Not a direct answer, but just a nudge in the right direction.

[LordShryku]

Even easier. Make your checkboxes an array

<input type="checkbox" name="email[]" value="theEmailAddress">

On the next page, to make the string, just use implode

<?
$emails = implode("; ", $_POST['email']);
?>

[sledgeweb]

Ah yes, that is a great idea. I knew an array would be helpful, just didn't have time to think through it.

Try the array approach.