sql_query("SELECT NOW() AS date_now"); foreach($now AS $data){ $date_now = $data['date_now']; } $month = substr($date_now, 5, 2); //get month $day = substr($date_now, 8, 2); //get day $get_birthday_celebrant_query = "SELECT * FROM customer WHERE DAY(date_of_birth) = " . $day . " AND MONTH(date_of_birth) = " . $month; echo $get_birthday_celebrant_query; ?>