While Loop

I am desperately trying to create an email form that has a number of checkboxes at the top of the page that allows the user to select multiple people (one email address per check box) or a department (multiple emails per checkbox).

I can get a single email address to echo from the database into the value fields for the people, but I am having issues getting all email addresses from specific column into a checkbox value.

I have been trying to learn to use the while loop but haven't managed to get it to work successfully yet.

To start with, I do not need to have checkboxes, but I do need a way that the user can select multiple people or groups of people to send the message to - if you have any other suggestions please let me know.

The method that I am using to loop the records is as follows;

<?php

$connection = mysql_connect("localhost", "username", "password") or die("Error connecting to database");

mysql_select_db("db_name", $connection);

$result = mysql_query("SELECT * FROM units", $connection) or die("error querying database");?>

Then this for the first checkbox;

<?php while($row_rs = mysql_fetch_assoc($result)){

echo $row_rs['chair_email'].',';}?>

Then this for the second;

<?php while($row_rs = mysql_fetch_assoc($result)){

echo $row_rs['sec_email'].',';}?>

But unfortunately the second set doesn't produce any results from the recordset.

Where am I going wrong?

I'm sure there must be an easier way....

When you get to the second loop the recordset is on the last record. It needs to be reset to the first record.

<?php
mysql_data_seek($rs, 0);
$row_rs = mysql_fetch_assoc($rs);
while($row_rs = mysql_fetch_assoc($result)){
echo $row_rs['sec_email'].',';}
?>

Im getting there slowly!!

The first set of loops work - horray!!!

<?php do { ?>

<?php if ($row_rs_users['lsdogs_chair']=="1")

echo $row_rs_users['email'].";"; ?>

<?php } while ($row_rs_users = mysql_fetch_assoc($rs_users)); ?>



<?php mysql_data_seek($rs_users, 0);

$row_rs_users = mysql_fetch_assoc($rs_users);

if ($row_rs_users['lsdogs_sec']=="1") 

{echo $row_rs_users['email'].";"; ?>

<?php } while ($row_rs_users = mysql_fetch_assoc($rs_users)); ?>

And the begining of the second set of loops works too!!

<?php do { ?>

<?php echo $row_rs_units['chair_email'].";";?>

<?php } while ($row_rs_units = mysql_fetch_assoc($rs_units)); ?>

But unfortunately the rest of that group of loops doesn't :0(

<?php mysql_data_seek($rs_units, 0);

$row_rs_units = mysql_fetch_assoc($rs_units);{

echo $row_rs_units['sec_email'].";"; ?>

<?php } while ($row_rs_units = mysql_fetch_assoc($rs_units)); ?>

So what am I doing wrong then.....?

This line of code does not look right:

$row_rs_units = mysql_fetch_assoc($rs_units);{

the "{" at the end should cause an error change it to:

$row_rs_units = mysql_fetch_assoc($rs_units);

the reason for the

{

is beacuse the next part is the

echo

followed by

}

and then the

while

.

So I assume that I would need to remove the closing one too?

I have been through the code and have removed all of the

{ }

which has not changed the output at all.

After the second set of loops, the remaining ones just show the first record only.

this code does not start a loop:
$row_rs_units = mysql_fetch_assoc($rs_units);{



You need to add another do { command:

<?php mysql_data_seek($rs_units, 0);

$row_rs_units = mysql_fetch_assoc($rs_units);

?>

<?php 

do {

echo $row_rs_units['sec_email'].";"; ?>

<?php } while ($row_rs_units = mysql_fetch_assoc($rs_units)); ?>