note 76915 added to function.strtotime

I needed a script to check the time that users weren't activated so I came up with this. <?php $username = $row_rstime['username']; $sql = "SELECT * FROM tblogin"; $result = mysql_query($sql); while($row_rstime = mysql_fetch_array($result)){ $activated = $row_rstime['active']; $when = strtotime($row_rstime['DateJoined']); // currently at "2007-05-24 20:50:53" if ($activated == 'Y' || time() < ($when+60*60*24*3)) { echo 'Keep '.$username.'<br>'; }else{ //Get the date and hour, 72 hours ago $minus = strtotime("-72 hours"); $date = date("Y-m-d H:i:s", $minus); $query = "DELETE FROM tblogin WHERE active = 'N' AND DateJoined <= '".$date."'"; $delete = mysql_query($query); echo 'Deleted '.$username.'<br>'; } } ?> ---- Server IP: 69.147.83.197 Probable Submitter: 198.54.202.214 ---- Manual Page -- http://www.php.net/manual/en/function.strtotime.php Edit -- https://master.php.net/note/edit/76915 Del: integrated -- https://master.php.net/note/delete/76915/integrated Del: useless -- https://master.php.net/note/delete/76915/useless Del: bad code -- https://master.php.net/note/delete/76915/bad+code Del: spam -- https://master.php.net/note/delete/76915/spam Del: non-english -- https://master.php.net/note/delete/76915/non-english Del: in docs -- https://master.php.net/note/delete/76915/in+docs Del: other reasons-- https://master.php.net/note/delete/76915 Reject -- https://master.php.net/note/reject/76915 Search -- https://master.php.net/manage/user-notes.php