Hello Tom,
I have been looking at this for an hour and thought it was something
like that but I could not see it. I guess it is time to go to bed.
Thanks
Monday, March 10, 2003, 1:47:27 AM, you wrote:
TR> Hi,
TR> 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]
TR> This resets $result
TR> //update the members table sent field with the key #
TR> $sql1="Update members set sent='$keys' where
email='$logged_email'";
TR> $result=safe_query($sql1);
TR> send_email();
TR> needs $result3 or something
--
Best regards,
Richard mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
