Sorting name

[Kunax]

Hello

having a DB full of names(band names) wished by people, im now stuck with howto sort hthis DB so i can output something usefull.

DB Table {id, bandname, date}

I would like to have it sorted so i get a count of each band name:

'band name XXX", "count"
'band name YYY", "count"

and so on, but how in hell do i sort that name and get a accurate count, when the name can be just about anything.

[Roger_Ramjet]

Read the manual for an explanation of how sorting works.

$sql = "SELECT * count(id), bandname FROM bands GROUP BY bandname ORDER BY bandname";

[Kunax]

sweet, i will try that tomorrow, now show my show other funky SQL

[Roger_Ramjet]

Whoops! Just noticed a typo: leave out the *