$bull = showdate("shortdate", time());
$shit = substr($bull,0,5);
$result = dbquery("SELECT * FROM ".DB_USERS." WHERE DATE_FORMAT(user_birthdate, '%m-%d') = '".$shit."'");
*I realize that I'm comparing a string to a value but don't know how to fix it*
Here is my problem. When pulling user birthdates from the users table I cannot use date("m") and date("d") in the query because it gets those values from the server time and date. I need to get data from the table based on local time and date. Server parameters don't account for the '-6' timezone difference I have set for Central Time but the time format settings (i.e. shortdate), does account for timezone settings. I hope this makes sense.