Re: while loop with mysql

Hi, Monday, March 10, 2003, 7:20:37 PM, you wrote: RK> Can somebody look at this and tell me way the first while loop will RK> only loop through the database once when there is more than one record RK> that should be processed. RK> while($members = @mysql_fetch_object($result)) { RK> $logged_email=$members->email; RK> $logged_title=$members->title; RK> $logged_first_name=$members->first_name; RK> $logged_last_name=$members->last_name; RK> $logged_time=$members->mtime; RK> $logged_date=$members->signdate ; RK> $logged_sent=$members->sent; RK> $current_time = time(); RK> $high_level = $current_time - $logged_time; RK> $low_level = $high_level - 86400; RK> $result1=safe_query("Select * from email"); RK> while ($emails = @mysql_fetch_object($result1)) { RK> $keys= $emails->days_send; RK> $keys=trim($keys); RK> $sendoff = $keys * 86400; RK> if ($sendoff > $low_level) { RK> if ($sendoff < $high_level) { RK> $logged_sent=trim($logged_sent); RK> if ($logged_sent==$keys){ RK> }else{ RK> //update the members table sent field with the key # RK> $sql1="Update members set sent='$keys' where RK> email='$logged_email'"; RK> $result=safe_query($sql1); RK> send_email(); RK> }}}//end of all three if statements RK> }//end of $emails while loop RK> } //end $members while loop RK> -- RK> Best regards, RK> Richard mailto:rdkurth@starband.net This resets $result //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(); needs $result3 or something -- regards, Tom