date query

[bcraig]

Im using PHP and i want to select records from my database where the month within a date datatype field is equal to a set variable. I dont know if this is possible?

 

 

I have this now

$dateFormat = date('m');
$monthNo = 10;

$sql_month = sprintf("SELECT * FROM gigs WHERE '%s' = '%s'", $dateFormat, $monthNo);

 

But that shows all records dated with all different months in the database

 

[aebstract]

How is your table set up? Need a little bit more information to help you out here.

[Barand]

SELECT * FROM gigs

WHERE MONTH(datecolname) = $monthNo