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
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:[EMAIL PROTECTED]
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
