Group By?

[chris_stfc]

Hi Guys,

Just wondering if I have:

Seven records saved in my database with the date: 2007-06-28
Eight records saved in my database with the date: 2007-06-29
Nine records saved in my database with the date: 2007-06-30

Is there any way I can group the records without actually knowing the date ie writing Where date =

in mysql statement.

Thanks

Chris

[guelphdad]

GROUP BY
datefieldname

but exactly what are you trying to do? Because what this will do is only return you three total rows.

perhaps you can show us by way of example data what you want to do.

If all you mean is show them in order then you would use

ORDER BY
datefieldname

and then they would show up in sequence by date with all 24 rows showing.

[chris_stfc]

Well what I kinda wanted to do is Order by date as you say and then kind <br /> each of them after each row ends in php? Is this possible.

Thanks

[earl-grey]

Well what I kinda wanted to do is Order by date

SELECT field_list
  FROM TABLE_NAME
ORDER
    BY DATE DESC

as you say and then kind <br /> each of them after each row ends in php? Is this possible.

Not sure what you mean by this.

[Speeple]

How about:

SELECT date, COUNT(date) AS count FROM table GROUP BY date ORDER BY date DESC;

this would allow you to do:

while ($row ...) {
$out .= "<br />{$row['count']} records saved in my database with the date: {$row['date']}";
}

echo substr($out, 6);

[guelphdad]

Do you understand how GROUP BY works? It collapses rows based on select criteria. So if you have 10 rows for June 30th and you use a GROUP BY on the date field, you will end up with a single row.

It sounds like you don't want to use GROUP BY at all but just to order your records using the ORDER BY as suggested above.