comparing dates

puja

i want to compare two dates called booking_start_date and booking_end_date to make sure that the booking start date comes before the booking end date.

at the moment both dates are just stored as dates in the mysql database.

anybody know how i could do this?

and also does anybody know how i can find the number of days that the booking is for based on the dates that the user has entered as it will be needed for me to calculate the price of their overall booking

thanks

esukf

<?
$date1 = "2006-05-05"; //booking start date
$date2 = "2006-05-15"; //booking end date

$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);

if($timestamp1 < $timestamp2){
	echo "Booking start date before end date";
}	else {
	echo "Booking start date after or is the end date";
}	

$date_diff = ($timestamp2 - $timestamp1)/(60 * 60 * 24);

echo '<br>';
echo 'days difference between '.$date2.' and '.$date1.' is '.$date_diff ;

/*
output:
Booking start date before end date
days difference between 2006-05-15 and 2006-05-05 is 10
*/
?>

puja

thank you
that really helps me out

puja