Date subtraction issues(again)

beyers

Howzit all.
Today I have a slight issue with subtracting a database field date from the current date. What I want is to get the table from the database, select the loan_date field(type DATE), subtract that from the CURDATE(). The way Im using date_sub() isnt working and using it in an if isnt working either. Please Please help. Here is the code for both of ways im trying.

Thanxs a mil.

$loanDateQuery = "SELECT * FROM loan WHERE loan_client_ID = " . $row['client_ID'];
if (!$loanDateQuery = mysql_query($query))
die("Could not load last loan date");
$lrow = mysql_fetch_array($loanDateQuery);

if ((date("d m Y") - (date("d m Y"), $lrow['loan_date']) > 31)
{ }

AND

$dateQuery = "SELECT loan_client_ID FROM loan WHERE DATEDIFF(CURDATE(), loan_date) > 31 AND loan_client_ID = " . $row['client_ID'];
if (!$dateResult = mysql_query($dateQuery))
die("Could not retrieve loan dates");

if ((mysql_num_rows($dateResult)) > 0)
			{ }

mrhappiness

SELECT loan_client_ID 
FROM loan 
WHERE 
  NOW() < loan_date + INTERVAL 31 DAY
  AND loan_client_ID = 5

what about that?

toplay

You didn't specify what error or exact problem other than saying it didn't work.

Well, I do not see a problem with your use of DATEDIFF() unless you don't have MySQL version 4.1.1 or higher. So, if you don't have at least that version, then I recommend you use TO_DAYS() SQL function instead. Example:

$dateQuery = "SELECT loan_client_ID FROM loan WHERE (TO_DAYS(CURDATE()) - TO_DAYS(loan_date)) > 2678400 AND loan_client_ID = {$row['client_ID']}";

If you're getting "Could not retrieve loan dates", then also display what the error is using mysql_error() function.

If you want to do it in PHP, then here's an example (I'm assuming date is in YYYY-MM-DD format):

if (time() - strtotime($lrow['loan_date']) > (60*60*24*31)) { // 2678400 seconds (31 days)
}

Let us know how it turns out.

beyers

Yeah I think this has sorted it, thanks a mil