now, i want to retrive record that hv year 2004 and month 5 (May)...
the following is the code i've tried to make it work.. but failed..
Code: Select all
$comm = mysql_query("SELECT sal_comm, ord_id FROM sales WHERE emp_id='$emp_id' AND year(sal_date)='2004' AND month(sal_date)='5'");tq...