What is the best way to go about grouping rows by the same timestamp?
- by Luke
Hello all.
I am looking for some advice.
I have rows of data in the database that i want to group together.
There is a timestamp involved.
That column is called date.
What is the best way to go about grouping rows by the same timestamp.
EDITED.....
<?
$result = mysql_query("SELECT * FROM ".TBL_FIXTURES." ORDER BY date");
$current_week = null;
while ($row = mysql_fetch_assoc($result))
{
if ($row['date'] != $current_week)
{
$current_week = $row['date'];
echo 'Week ' . $current_week .': ';
}
echo $row['home_user'];
echo $row['home_team'];
echo $row['away_user'];
echo $row['away_team'];
}
?>
I have this code. What i am trying to do is organise each round of fixtures in a row with a title Week 1 - date.
I want Week 1 and the date and all fixtures with that date displayed.
Then move onto week 2 and the date and all fixtures again.
This should be done for every fixture in the database, so if there are 6 rounds of fixtures, there will be 6 dates and therefore 6 blocks of fixtures..
Please help, thanks
