sql sytax question

hello,

i have a date field yyyy-mm-dd that is the member_since field for a database.

i'm trying to pull all users whose anniversary date is equal to today.

so, i get today's date in mm-dd format. only thing is, i'm not sure of the syntax for the sql.

i thought something like this:

$users = $db->get_results("SELECT name, email FROM users where (date_format(member_since, '%c/%e') as anniversary) = '$thismonth'");

of course, this isn't quite working.

suggestions?

$now = mktime();

$sql = "SELECT name, email FROM user
             WHERE anniversary = $now";

can add some more parameters through mktime and date functions to tweek it the way you want it to work.

i guess that's my question, then.

because the anniversay date field in mysql is formatted with the year they joined.

so, i have to match today's month/day to that fields month/day only. how do i check the date using only the month/day?

it depends on which way you have posted it into the db

eg if its in you db: yyyymmdd, just make sure you varialble holding the date is the same, otherwise for a broader search, use LIKE in you sql query