choose records from last month... Mysql

[tgignac]

Hi folks, I seem to have a problem with my script for only getting records from the previous month... my script is below: Any help would be greatly appreciated

*<?php require_once('../../Connections/MySQL.php'); ?>
<?php
$month = date('n');
$year = date('Y');

$lastmonth = $month-1;
if ($lastmonth==0) { $lastmonth=12; $year--; }

$startdate = $year . '-' . $lastmonth . '-01';
$enddate = date('Y') . '-' . $month . '-01';

mysql_select_db($database_MySQL, $MySQL);
$query_Recordset1 = "SELECT * FROM PlanInsp WHERE InspDate>='" . $startdate . "' AND InspDate<'" . $enddate . "' ";
$Recordset1 = mysql_query($query_Recordset1, $MySQL) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>*

 

[DRJ478]

I think you make it more complicated than necessary.
Use the MySQL function MONTH

SELECT * FROM PlanInsp WHERE MONTH(InspDate) = MONTH(NOW)-1

Something similar like that.

 

[michelleqw]

At the moment I am using the mktime() function. The date is converted into a number. There no converting problem and it is a little bit faster.

Michelle,