5 days left to the end time of project? How to do ? Simple question....

miha

I have code and do not know if it is correct:

            while($row = mysql_fetch_array($result))
                    {
                     $endtime = $row["endtime"];
                     $now = time();
                     $notice=5 * 24 * 60 * 60;

                }
    if ($now<($endtime-$notice))

    {echo 'Project is near End and less then 5 days' ; }

}

ppowell

A wee bit of alteration:

$now = time();
$notice = 86400 * 5;
while ($row = mysql_fetch_array(result)) 
 if ($row['endtime'] && $now < $row['endtime'] - $notice) echo '...';

You might want to put setting $now and $notice outside of the loop to be more efficient as well as check to see if $row['endtime'] has a value, other than that, looks straightforward to me.

Phil
Phil

Weedpacket

Wouldn't it be simpler to do this in the query itself? "Select ..., NOW()-endtime<INTERVAL 5 DAY AS near_end"? (Caveat: I don't use MySQL, so I'm guessing the syntax it uses.)

miha

Phil
thanks for your suggestion.
I have two questions:
1. Why is there AND operator: $row['endtime'] && $now
If I understand it will check if endtime exist?

How to do it that server will automatic detect this formula and e.g. send E-mail?
Problem is that I do not want that user goes on server and server will check time. It should be automatic 🙂