Can somebody look at this and tell me way the first while loop will
only loop through the database once when there is more than one record
that should be processed.
while($members = @mysql_fetch_object($result)) {
$logged_email=$members->email;
$logged_title=$members->title;
$logged_first_name=$members->first_name;
$logged_last_name=$members->last_name;
$logged_time=$members->mtime;
$logged_date=$members->signdate ;
$logged_sent=$members->sent;
$current_time = time();
$high_level = $current_time - $logged_time;
$low_level = $high_level - 86400;
$result1=safe_query("Select * from email");
while ($emails = @mysql_fetch_object($result1)) {
$keys= $emails->days_send;
$keys=trim($keys);
$sendoff = $keys * 86400;
if ($sendoff > $low_level) {
if ($sendoff < $high_level) {
$logged_sent=trim($logged_sent);
if ($logged_sent==$keys){
}else{
//update the members table sent field with the key #
$sql1="Update members set sent='$keys' where
email='$logged_email'";
$result=safe_query($sql1);
send_email();
}}}//end of all three if statements
}//end of $emails while loop
} //end $members while loop
--
Best regards,
Richard mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
