I'm new to MySQL and I need help writing a query.

I have a table with fields for:

- FirstName
- MiddleName
- LastName
- BirthDay
- BirthMonth
- Birthyear

I want to query the database for all those whose BirthMonth is equal to the currentMonth and whose BirthDay is greater than or equal to the currentDay.

Basically...
BirthMonth == currentMonth AND BirthDay >= currentDay

How would I write this as a MySQL query?

- J2

PHP Code:

// Determine the date and month
$day = date( "j" );
$month = date( "m" );

$sql = "SELECT * from theTable WHERE BirthMonth = $month AND BirthDay >= $day"; 


Thanks. :-)

- J2