$sql = 'select * from table group by email';
$res = mysql_query($sql);

while($row = mysql_fetch_array($res)) {

// then something like so
mail($row['name'] . '<' . $row['email'] . '>', 'blah subject', $msg);


}

$sql = 'select * from table group by email';
$res = mysql_query($sql);

while($row = mysql_fetch_array($res)) {

$nameEmail .= $row['name'] . '<' . $row['email'] . '>, ';

}


  // then something like so
  mail($nameEmail, 'blah subject', $msg);

<?php

$start_num = mysql_real_escape_string(file_get_contents('email_number.txt'));
$num_per_exec = 500;

// If this is the first time this script is run,  count the records in the database
// so we know when to stop (preg match checks to macke sure retrieved value is xx/xx (meaning thismanysent/thismanytotal)
if (!$start_num || !preg_match('/^\d+\/\d+/', $start_num))
{
    $start_num = 0;
    $sql = "SELECT COUNT(*) as num FROM table group by email";
    $result = mysql_query($sql);
    $num = mysql_fetch_row($result);
    $num = $num['num']; // total number
} else {
  // Explode into (number to start from and total
   list($start_num, $num) = explode('/', $start_num);
}

$sql = 'select * from table group by email LIMIT ' . $start_num . ', ' . $num_per_exec;
$res = mysql_query($sql);

while($row = mysql_fetch_array($res)) {

// then something like so
mail($row['name'] . '<' . $row['email'] . '>', 'blah subject', $msg);

// Now recalculate where we're up to

$start_num += $num_per_exec;

if ($start_num > $num)
{
     shell_exec('something in here to delete the cron job you set up);
}

Still good so write to the file

file_put_contents('email_nu,mber.txt', $start_num . '/' . $num);

}


?>