Counting records for the last month

[furious5]

I am currently trying to count through some records within a table, and return a figure based on any records placed within the last month.

At the moment I am really struggling with the SQL, can anyone help me out?

$date = 30;
$numdays = date('Y-m-d', mktime(0,0,0,date('d'), date('m')-$date, date('Y')));
$sql = "SELECT COUNT(DISTINCT jobid) AS jobid, UNIX_TIMESTAMP(date) AS udate FROM job WHERE date <= '$numdays'";

[HalfaBee]

Try this

$month = (int)date('m');
$sql = SELECT ... where MONTH(date)=$month

HalfaBee

[Sxooter]

Try something like this:

$start = "20030901";
$end = "20030931";
$query = "select count(*),max(unixtimestamp(date)) from table where date between '$start' and '$end group by jobid";