Does PHP have a Month() function like MySQL?

[marms]

I have a problem I just can't figure out.

I have a contact managment system that has a "client" table with a FirstName, LastName, and DateOfBirth. On the same record I could have a SpouseName with a SpouseDateOfBirth.

My client requires to be able to pull up all birthdays being either a main client or the spouse, but needs the Name of the one with the birthday to show up in this mail merge spread sheet I generate.

So part of my MySQL WHERE clause is:

AND ((MONTH(DateOfBirth) >= $DOBFrom AND MONTH(DateOfBirth) <= $DOBTo) OR (MONTH(SpouseDateOfBirth) >= $DOBFrom AND MONTH(SpouseDateOfBirth) <= $DOBTo))

And this will pull up all birthdays in the given month range they desire. Now my problem is as I loop over the recordset I need some PHP code I assume to tell if is the main person's birthday it found on that record or the spouses birthday so I can place the correct name in the "name" field in the mail merge sheet I generate.

Does anyone have any ideas? I am really stuck and my client thinks this should be simple to do.

Thanks

[Sxooter]

Just add those parts of your where clause to your select list, like so:

select *, MONTH(DateOfBirth) as dob, MONTH(SpouseDateOfBirth) as sdob from table where...

[marms]

Thanks, that worked great. Feel stupid I didn't think of that one.

[Sxooter]

I actually used postgresql's intervals to do some date math on stuff that wasn't in the database once, and it worked great, something like

select '2001-03-11'::date - '2001-03-02::date';

For some calendar thing I was working on. Worked a charm.