Please Help!!

[webqueen79]

I am trying to retrieve data from a table by a specified date period. There are multiple entries for each date and I need to display them on the page by the date and then all the entries for that date. I know that I need to use GROUP BY in my sql query, I am just having a hard time figuring out how to do that and then how to display the results on the page.

Can someone please help me??

Thanks.

---

SELECT *
FROM <table>
WHERE <date column>
BETWEEN <date1> AND <date2>

Do the further date logic in your PHP as you have multiple rows with different data with the same date, GROUP BY will group the dates and your data from that column will be lost.

---

Do you know what the further PHP code is? I can't figure it out.

[crislewis]

Forget GROUP and use ORDER BY date_column. This will return your record set with all the records for each date together. Now the logic required to display this is straight forward unless you need to display records in a specific order within the each date in which case add the additional sort columns to your order by clause, e.g. ORDER BY date_column, username . . .

[phpstuck]

Exactly!

IE:

$sql = mysql_query(
"ALTER TABLE tablename ORDER BY fieldname");

Just put it before your SELECT query and it will work magic :-)