[Resolved] Comparing the difference in days between 2 dates

Calahan

I have spent a few hours looking around the net and I think I have most of what I need but I am stuck at the point where I need to put it all together!
This is what I have so far:

$member_since_day="SELECT DATE_FORMAT('$row[createdate]', '%d')";
$member_since_month="SELECT DATE_FORMAT('$row[createdate]', '%m')";
$member_since_year="SELECT DATE_FORMAT('$row[createdate]', '%Y')";
$current_day=date("d");
$current_month=date("m");
$current_year=date("Y");

$unixtime_since=mktime(0,0,0,$member_since_month,$member_since_day,$member_since_year);
$unixtime_now=mktime(0,0,0,$current_month,$current_day,$current_year);

Now, what I need is the time in days between the user having registered and the current day. I know that the calculation will return the time in seconds, but from there it's easy to work out how many days the seconds translate into.
So am I way off here or am I (hopedully) just missing something small?

Thanks for any suggestions.

laserlight

Yes, you should be on the right track.

Just implement and test your code to see.

Hiccup

Yep you pretty much have licked. Here's the rest:

$now = time();
$passed = $now - $unixtime_since;

$days = $passed / 86400; //which is 60 x 60 x 24

Now $days is the number of days since they registered!

Calahan

Seems I wasn't as close as I thought! Needed a fair bit more code to make it work. The code below does the job well enough but I get the feeling that it could be shorter so if anyone wants to tell me if I have gone about this the long way and offer an alternative, it would be good to know. For anyone else trying to do the same on their website, I hope this offers some help.
🙂

$member_since_full_query="SELECT DATE_FORMAT('$row[createdate]', '%W %D %M %Y')";
$member_since_day_query="SELECT DATE_FORMAT('$row[createdate]', '%d')";
$member_since_month_query="SELECT DATE_FORMAT('$row[createdate]', '%m')";
$member_since_year_query="SELECT DATE_FORMAT('$row[createdate]', '%Y')";
$current_day=date("d");
$current_month=date("m");
$current_year=date("Y");
////////////////////////////////////////////////////////////////
$member_since_result=mysql_query($member_since_full_query)
or die (mysql_error());

while($row = mysql_fetch_row($member_since_result))
	{
	echo "<center><b>You have been a member since: $row[0].</br>";
	}
////////////////////////////////////////////////////////////////
$member_since_day_result=mysql_query($member_since_day_query)
or die(mysql_error());

while($row = mysql_fetch_row($member_since_day_result))
	{
	$member_since_day=$row[0];
	}
/////////////////////////////////////////////////////////////////
$member_since_month_result=mysql_query($member_since_month_query)
or die(mysql_error());

while($row = mysql_fetch_row($member_since_month_result))
	{
	$member_since_month=$row[0];
	}
/////////////////////////////////////////////////////////////////
$member_since_year_result=mysql_query($member_since_year_query)
or die(mysql_error());

while($row = mysql_fetch_row($member_since_year_result))
	{
	$member_since_year=$row[0];
	}
/////////////////////////////////////////////////////////////////
}

$unixtime_now=mktime(0,0,0,$current_month,$current_day,$current_year);
$unixtime_since=mktime(0,0,0,$member_since_month,$member_since_day,$member_since_year);

$now = $unixtime_now;
$passed = $now - $unixtime_since;

$days = $passed / 86400; //which is 60 x 60 x 24

echo "That was $days days ago</b></center>";

nemonoman

Use the database and do this in one query

SELECT to_days( Now( ) ) -to_days( createdate ) FROM sometable

This will retun an integer number of days between now and createdate

tekky

$member_since_full_query="SELECT DATE_FORMAT('$row[createdate]', '%W %D %M %Y') AS member_since, DATE_FORMAT('$row[createdate]', '%d') AS since_day, DATE_FORMAT('$row[createdate]', '%m') AS since_month, DATE_FORMAT('$row[createdate]', '%Y' AS since_year)";
$current_day=date("d");
$current_month=date("m");
$current_year=date("Y");
////////////////////////////////////////////////////////////////
$member_since_result=mysql_query($member_since_full_query)
or die (mysql_error());

while($row = mysql_fetch_assoc($member_since_result))
	{
	echo "<center><b>You have been a member since: $row['member_since'].</br>";
	$member_since_day=$row['since_day'];
	$member_since_month=$row['since_month'];
	$member_since_year=$row['since_year'];
}

$unixtime_now=mktime(0,0,0,$current_month,$current_day,$current_year);
$unixtime_since=mktime(0,0,0,$member_since_month,$member_since_day,$member_since_year);

$now = $unixtime_now;
$passed = $now - $unixtime_since;

$days = $passed / 86400; //which is 60 x 60 x 24

echo "That was $days days ago</b></center>";

That would also work eliminating a ton of DB queries, note combined all the queries into one, and used the AS keyword to name your query values, and used mysql_fetch_assoc to fetch an associative array so you can use $row['queryvalue'] instead of $row[0-5]

(just posting an alternate solution thats lots shorted also) ultimately, the above post, is the shortest I would say that this code could go 🙂

Calahan

Knew there would be a shorter way 🙂
Thanks for the info.