I have a mysql table.that look like
id product product_date
1 5 5/5/2004
2 6 7/5/2004
3 9 8/6/2004
The date type like this
id int(3)
product int(3)
product_date date
I want to get the amount between 5/1/2004 to 7/31/2004.please let me know how to write the sql statement.
select count(product) where ????
I confuse with mysql date format.is this like m/d/yyyy or d/m/yyyy?
and how to insert a date file with php code
Thanks