Generating Last Month

[Nvenom]

im Trying to grab data based on the month

EX:

You have Made 9 Tacos This month
You have Made 15 Tacos Last month

Im just having an issue generating a "Simple" start date and end date for the current month and the month before it. i need these months to be really accurate including the 28 days in febuary and leap years etc..

i have tried playing around with the date function but have had to much trouble trying to get it to format start and end dates for each month for the grab query.

$today = getdate();

$year = $today['year'];
$month = $today['mon'];

if ($today['mon'] == 2)
{
$this_month_start = "$year-$month-1";
$this_month_end = "$year-$month-28";
$last_mon = $today['mon'];
if ($last_mon == 1) {$last_mon = 12;} else {$last_mon = $last_mon - 1;}
$last_month_start = "$year-$last_mon-1";
$last_month_end = "$year-$last_mon-31";
}
if ($today['mon'] == 4 || $today['mon'] == 6 || $today['mon'] == 9 || $today['mon'] = 11)
{
$this_month_start = "$year-$month-1";
$this_month_end = "$year-$month-30";
$last_mon = $today['mon'];
if ($last_mon == 1) {$last_mon = 12;} else {$last_mon = $last_mon - 1;}
$last_month_start = "$year-$last_mon-1";
$last_month_end = "$year-$last_mon-31";
}
if ($today['mon'] == 1 || $today['mon'] == 3 || $today['mon'] == 5 || $today['mon'] == 7 || $today['mon'] == 8 || $today['mon'] == 10 || $today['mon'] == 12)
{
$this_month_start = "$year-$month-1";
$this_month_end = "$year-$month-31";
$last_mon = $today['mon'];
if ($last_mon == 1) {$last_mon = 12;} else {$last_mon = $last_mon - 1;}
if ($last_mon == 2) {$dd = "28";} else {$dd = "30";}
$last_month_start = "$year-$last_mon-1";
$last_month_end = "$year-$last_mon-$dd";
} 

if anyone has a better way to grab queries in a certain month that would be awesome, i also can not have a row just listing the current months name it needs to pull Date format Y-m-d

it works, its just seems like there should be an easier way to do this and one that actually counts leap years.

Thanks ~

[007Julien]

Try this :

echo "<br>Today ".date('r');
echo "<br>Month start ".date('r',mktime(0, 0, 0, date("m") ,1, date("Y")));
echo "<br>Month end ".date('r',mktime(0, 0, 0, date("m")+1, 0, date("Y"))); 

The last day of the month is too the «day 0» of the following month !

[NogDog]

$lastDayOfMonth = cal_days_in_month(CAL_GREGORIAN, $monthNum, $yearNum);