Hello,
I need help formating the output of my query. I'm pulling my hair out! I have a query that selects between two dates then groups by date.
$query = "SELECT date, some2, some3 FROM tble where date BETWEEN '2004-03-23' AND '2004-03-25' GROUP BY date";
$result = mysql_query($query);
while($get_results = mysql_fetch_assoc($result)){
echo "<tr>\n";
echo "<td>$get_results[date]</td>\n";
echo "<td>$get_results[some2]</td>\n";
echo "<td>$get_results[some3]\</td>n";
echo "</tr>\n";
}
What I'd like to do is put some sort of divider between the date results.
example:
2004-03-23 DATA DATA
2004-03-23 DATA DATA
2004-03-23 DATA DATA
2004-03-24 DATA DATA
2004-03-24 DATA DATA
2004-03-24 DATA DATA
2004-03-25 DATA DATA
2004-03-25 DATA DATA
2004-03-25 DATA DATA
Thanks