difference of dates

crawfd

I want to take the difference from my 'last_login' field and my 'regdate' field. If the difference is equal to 30 days, redirect to page. How would I write this??

$query = "SELECT regdate, last_login FROM users WHERE username = '".$_POST['username']."'";

rpanning

You can do this in the query and get the info if the date difference is greater than or equal to 30 days. I think the query would be:

$query = "SELECT regdate, last_login FROM users WHERE username = '".$_POST['username']."' AND DATEDIFF(regdate, last_login) >= 30";

crawfd

shouldn't I do something like this?

$query = "SELECT regdate, last_login FROM users WHERE username = '".$_POST['username']."'";

if (DATEDIFF($regdate, $last_login) >= 30") {

echo "fail";

}

else {

echo "pass";

}

crookedgoomba

that won't work because DATEDIFF is a mysql function, not PHP. if you want to test if it successful, try:

if(mysql_num_rows($query) > 0){
     echo "pass";
}else{
     echo "fail";
}

freebie

You can and should do this using SQL not PHP.
Also, Don't use DateDiff. Your version of MySQL probably doesn't support it as it was only added in the most recent versions.

Here's what you should do:

$SQL="select * from users where username='".$_POST['username']."' AND DATE_ADD(regdate, INTERVAL 30 DAY) > last_login";
if(mysql_num_rows(mysql_query($SQL))>0){
   header("Location /myotherpage.php");
   exit;
}

-- hth

crawfd

This doesn't seem to be working:

If the user's account is older than 30 days old, redirect them to the address in the redict statement. If under 30 days, continue the script and load page.

I have placed the below code in the header of my html page....


<?
$SQL="SELECT regdate, last_login FROM users WHERE username='".$_POST['username']."' AND DATE_ADD(regdate, INTERVAL 30 DAY) > last_login"; 
if(mysql_num_rows(mysql_query($SQL))>0){ 

   print "<script type=\"text/javascript\">window.location = \"home.php?page=manage&action=billing\";</script>"; 

   die;
}
?>


//body html here