[Resolved] display records automatically based on dates

[theo]

I am trying to display database details based on people birthdays.

I have a field that stores the customers birthday and want to display their records automatically if they match todays date.

I can get it to work if it matches the entire record by putting date("d/m/Y") into a variable and matching it to the field.

The problem I have is I only want it to match the days and months not the years. I have put date("d/m") into a variable but I need to remove the year from the field when I select it from the database. I know the function is strstr() but can I do it in the select query as I don't seem to be able to get it to work?

[theo]

sorry - i meant substr not strstr

[Shrike]

$sql = "SELECT user FROM users WHERE ".date("d")." = DAYOFMONTH(birthday) AND ".date("m")." =  MONTH(birthday)";

Something like that, it will require your birthday's column to be a date type (yyyy-mm-dd).

You might be able to combine the DAYOFMONTH and MONTH function calls, not sure. Also MySQL returns days of the months < 10th as single integers so you'd need to call the correct PHP date parameter 🙂

[theo]

Great thanks