hi guys i have a qualm. I am developing a website that when the user logs in, the summary page will display the nearest birthday from the database. What kind of php query would I use. I know that I need to get the date via php so should the query be along the lines of
“SELECT * from database WHERE $date <= $todaysdate (by 14?) && $month <= &todaysmonth (by1)” syntax is way off but thats kinda what I need to create. If there is a birthday in the database within 14 days and 1 month of todays date I would like it to be displayed.
any ideas or suggestions on the workings of this. I’m lost and struggling lol
:fab: