I have rows in a MySQL database, and each has a timestamp value. (ie 1340296188)
I am trying to find all entries for the last 7 days. I know how to do a query to find all WITHIN the last 7 days, something like:
$lastweek = time() - 604800;
$results = mysql_query("SELECT * FROM table WHERE timestamp > $lastweek");
However, I need to be able to get each day seperately. How would I do this query? I don't know how to find from the above results which ones are for which specific date.