Hello,
I'm trying to sort out rows in a table by date, so you retrieve entries per day. So firstly I need a query to get the number of entries per day, and secondly, I need a query like:
"SELECT * FROM orders WHERE DAYOFMONTH(o_datenew)=$selected_month"
That last part works fine, but how do I do the first part? I get a working query, but I don't know how to retrieve the data into PHP.
Could someone please set me up with an example?
thanx
Low.
I'm trying to sort out rows in a table by date, so you retrieve entries per day. So firstly I need a query to get the number of entries per day, and secondly, I need a query like:
"SELECT * FROM orders WHERE DAYOFMONTH(o_datenew)=$selected_month"
That last part works fine, but how do I do the first part? I get a working query, but I don't know how to retrieve the data into PHP.
Could someone please set me up with an example?
thanx
Low.