Hi,
I need to print all the orders with the month in the Monthly Order Report.How should I do it.Can someone tel me how to do it...
This is my query.Order date should equal to the relavent month...
$this->result = mysql_query("SELECT * FROM tbl_order,tbl_order_items WHERE tbl_order.order_id=tbl_order_items.order_id AND tbl_order.order_status='accepted' AND order_date= ............... ORDER BY tbl_order.order_id");
Thanks in advance..:)