Number of days recorded added & today

clarkm

I want to compare the date the record was added to the database to
today's date, and get that result as a number.

$today = date("Y-m-d");

$row = mysql_fetch_array($sql_result);
$date_added = $row["date_added"];

$date_calc = ???
Here's where I am unable to solve the problem. I want
to look at $today and $date_added ($date_added pulled from
database, both in YYYY-MM-DD format) and get the result in a
number of days difference. So I can then do an if statement:

if ($date_calc < 7) {
echo "<font color=red><b>new</b></font>";
}

Thank you,
Mark

Anon

You need to use mktime() to convert both dates into a format you can do the calculation with.

I got a script from www.hotscripts.com to do something similar, but mktime is the way to go (it gives the number of seconds since 1st Jan 1970 I believe)

Anon

Yes, you can use James's idea with using the mktime function. You can also use this SQL statement in the query you use to retrieve the record date :

$Query = "SELECT (TO_DAYS(CURRENT_DATE)-TO_DAYS(date_added)) AS diff_date FROM <table> WHERE ...";

So your code will be :
$sql_result = mysql_query($Query);
$row = mysql_fetch_array($sql_result);
$date_added = $row["diff_date"];

if ($date_added < 7) {
echo "new";
}

...