I need some help here.. I want to select a interval of dates based on now(), where it start 7 days ago and go to 14 days after.. I've tried to use a function to calculate start/end date, but unhappy its wont work too..
My printed sql is:
SELECT id , data_nascimento , nome FROM tbShalom_Alunos WHERE data_nascimento >= "22/05" AND data_nascimento <= "12/06" ORDER BY SUBSTRING( data_nascimento , 7 , 2 ) ASC , nome ASC22/05 and 12/06 is a datee() php type, I can print it as I wish, 'd/m' is on..
Thanks for any help =)