sql: getting birthday where datatype != timestamp

[remote2]

i need to get member's birthday which is today...
but when i design my mySQL database... i didn't use the date datatype...

i use the time() function in PHP...

i was thinking of pulling all the members from the database..
then put it into a for loop and use if statement to check...

but the cost of that is O(n)...
so i think there maybe an easier way...

any ideas?? suggesting???

thx thx

[nnichols]

If you have the data to do your comparison with an if() statement, you also have the data to do the comparison on the database.

If you want a more detailed reply I suggest you post your code with details of the format you are using to store the date and the field type used.

There is "NO" good reason to use a non DATE/TIME datatype. With the formatting functions available in both php and mysql you can return the date in any format you want.