date culculation

moon

hi there,
how can i calculate the no of days between to days given by the user when they fill in the fields. let's say the field name is date_from, date_until

some people say use mktime, but when i checked it, it is in different format that mysql doesn't support.

you can view my files, and look what i did?
i used to receive 0 when i apply in the form.

the function is date_diff
it is stored in a file called mydate.php
approve_app.php is the file where i called the date_diff function.
can anybody help me: my email is: munti@karate.com

phpbuild-it

Try this function

// Total days, include start and end date
function days_between($date_from, $date_to)
{
$a_date_from = explode("-",$date_from);
$a_date_to = explode("-",$date_to);

 $d1 = mktime(0,0,0,$a_date_from[1],$a_date_from[2],$a_date_from[0]); //midnite of date_from 
 $d2 = mktime(0,0,0,$a_date_to[1],$a_date_to[2],$a_date_to[0]); //midnite of date_to 
 return (round(($d2 - $d1) / 86400) + 1); //difference in seconds between days divided by 86400 (seconds in day) gives you difference in days

}

Should be self-explanatory

Weedpacket