[plug] Mysql limit problem

Shayne O'Neill shayne at guild.murdoch.edu.au
Fri Feb 7 13:40:03 WST 2003


Ok I've got a bunch a records in a mysql database with appointments time
in a datetime field.What SQL would I send to mysql to retrieve only the
fields in a particular month if I have $global_month and $global_year defined

(Ie

$global_month = 2;
$global_year = 2003;

SELECT * from appointments where ?????????

I'm stumped... Cheers,

Shayne.



More information about the plug mailing list