$result = mysql_query( "SELECT *, DATE_FORMAT(DOB, '%M %e, %Y') AS formatted_date FROM ENTITY WHERE RIGHT(DOB,6) = RIGHT(CurDate()+7,6) ORDER BY DOB ASC" );
how can I change this to give all birthdays (this week) rather than today?
what I have above doesn't work
