time between now and next month

[nephish]

hey there,
i have a php script that selects all records on a month by month basis and calculates the amount of time of certain conditions..

so what i need to know is how to figgure out the amount of time in seconds between the last datetime and the first second of the next month.

for example, if the last datetime in a certain month was 2006-08-21 12:14:23, how is the best way to find the number of seconds between that date and 2006-09-01 00:00:00 ?

it would be easy to do with math, but not every month has the same number of days in it.

if there is a MySQL query that can do that, i could use that too.

thanks

[konrad]

<?php
 $date = getdate();
 $next_month = $date['mon']%12+1; // add 1 to the current month
 $year = ($next_month == 1)?$date['year']+1:$date['year']; // add 1 to year if $next_month is January of the next year
 echo mktime(0,0,0,$next_month, 1, $year) - time(); 
?>
 

[nephish]

wow, thanks very much konrad, i had no idea how to pull this off.

cheers, and thanks again