while loop with mysql
| From: | Richard Kurth | Date: | Mon, 10 Mar 2003 09:20:37 +0000 |
| Subject: | while loop with mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-138935@lists.php.net to get a copy of this message | ||
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:rdkurth@starband.net