PHP Query Search - birthday match

I've got a site thats been made in Joomla with Jomsocial. I have a module that you enter an age range and it searches the MySQL database for users ages and gives the results in a list.

I need it changing to be a field that you enter your birthday (day and month) and it searches the MySQL database and presents users who have the same birthday. It is probably quite a simple search query but i'm no programmer.

The module i'm using is on the jomsocial website under add-ons (a Google search for "Jomsocial Dating Search" brings it up).

.....but it might be easier to write this from scratch (not sure).

There are loads of PHP examples that show birthdays coming up but not a searchable field for any users who have the birthday you type in.

Any help greatly appreciated.

There's sort of a lot wrapped into that question

You're going to need to do a few things,

1. create the form that will submit the date to search for (in the format you want). Usually, I let a user enter the date a few different ways, then reformat it before I work with it (i.e. 09/18/1975 or 9.18.1975 or 9-18-1975 etc.).

2. Format the date entered so it matches the birth date field from the database so you can compare them properly.

3. Then it's a pretty straight forward query to get the people where the dates match.

There is a decent amount of ground between where you're at and where you want to go though.

that should at least give you an idea of where to start. If you would like some coding help, post the code you want to incorporate this into.