Differnce in days

[DeanWhitehouse]

I have this code for the difference in days , but i think i am doing something wrong as it is not returning the correct result.

 

<?php 
$today1 = $rows['started_on']; 
$today1 = date("d.m.Y",strtotime($today1)); 
$f_date1 = $rows['completed_on'];
$f_date1 = date("d.m.Y",strtotime($f_date1 )); 
$difference = intval(($f_date1 - $today1)/86400+1);  
echo $difference;
?>

 

The $rows are stored in this format (2008-08-07 21:43:10), any ideas. Note: i will need it to work out the amount of days from when i started to when i finished, that may go into another month.

[BlueSkyIS]

problem may be you're using the date() function to put the times into "d.m.Y" format before trying subtract.

[AndyB]

Does it help to know that the date() function allows you to find the day of the year (starting from zero)?

[DeanWhitehouse]

Bluesky, i didnt write the code i found it (google) so i dont know, any  help would be good.

 

And AndyB that may help, but doing it using that would be the long way i beleive?

[discomatt]

You're getting the date from a MySQL database?

 

mysql> SELECT TO_DAYS(NOW()) - TO_DAYS('2008-08-07 21:43:10') as `difference`;
+------------+
| difference |
+------------+
|         44 |
+------------+
1 row in set (0.00 sec)

[DeanWhitehouse]

would that be

$sql = "SELECT * FROM news SELECT TO_DAYS(".$new_time.") - TO_DAYS(".$old_time.") as `difference`;"

 

[discomatt]

No...

 

$sql = "SELECT *, (TO_DAYS(NOW()) - TO_DAYS(`completed_on`)) as `difference` FROM news;"

 

And you use $rows['differece'];

[DeanWhitehouse]

ok, thnks will try it

 

[DeanWhitehouse]

bit of a prob

this is my code

$sql = "SELECT *, (TO_DAYS(".$rows['started_on'].") - TO_DAYS(`".$rows['completed_on']."`)) as `difference`  FROM sites WHERE id = '$site_id' AND member_id = '$id'";// this is my problem, the vars need to be retireved from the db , do i need to reset the pointer if so how?
$query = mysql_query($sql);
$number = mysql_num_rows($query);
?>
<p align="center" style="text-align:left; margin-left:5px;">	
<?php
if($number == 0)
{
	echo "Either the site is not registered , or the site is not registered to this username. Please check and try again.";
}
else
{
	while($rows = mysql_fetch_assoc($query))
	{
	echo $rows['difference'];
                }
?>

[DeanWhitehouse]

I dont think any one actually saw the comment so here it is

this is my problem, the vars need to be retireved from the db , do i need to reset the pointer if so how?

 

corresponds to this line

$sql = "SELECT *, (TO_DAYS(".$rows['started_on'].") - TO_DAYS(`".$rows['completed_on']."`)) as `difference`  FROM sites WHERE id = '$site_id' AND member_id = '$id'";