Group By Date

[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.

[goldlikesnow]

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.

[webqueen79]

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

[goldlikesnow]

Could be similair to this:

while ($fetchArray = mysql_fetch_array($sqlStatement, MYSQL_ASSOC)){
$value[] = $fetchArray['columnNameWhatever'];
$date[] = $fetchArray['date'];
}
echo $date[0] . "<br />";
for($i=0, $j=-1; $i<count($columnArrau); $i++, $j++){
//if previous date is same as present then skip
if ($i && $date[$i] != $date[$j]) echo $date[$i] . "<br />"
//echo your other variables
echo $value[$i] . "<br />";
}

[webqueen79]

Thank you, that worked great!