[RESOLVED] mysql date time

[screative]

I am scratching my head on this one. I am trying to get the first and last day of a month and then search a mysql datetime column for dates that are between the first day and last day. When I try to format the dates.. it seems to break . Any ideas??

$archivedate = 'July-2006';

$firstday = date("m-1-y",strtotime($archivedate));
$lastday = date("m-t-y",strtotime($archivedate));

// this prints 07-1-06 - 07-31-06
print $firstday." - ".$lastday."<br><br>";

$firstday = date("Y-m-d 00:00:00",strtotime($firstday));
$lastday = date("Y-m-d 23:59:59",strtotime($lastday));

// this prints 2007-01-06 00:00:00 - 1969-12-31 23:59:59
print $firstday." - ".$lastday."<br><br>";

[screative]

this is php 5 dependent because i used 't' to get the last day of the month.

[screative]

I also tried formating it like this:

$archivedate = 'July-2006';

$firstday = date("m-1-y 00:00:00",strtotime($archivedate));
$lastday = date("m-t-y 23:59:59",strtotime($archivedate));

and then i do a mysql select like this:

"SELECT * FROM cmsblogposts where postdatetime between '$firstday' and '$lastday'"

and still no luck.

[screative]

I fixed.. not sure how i did.. but it is done.