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.