sorting alphabetically

skdzines

Does anyone know of a function that will sort an array alphabetically? I have a database of artists and songs and want to be able to sort them alphabetically according to the artist.

Thanks

marian

you can use asort(), sort() etc to sort any array alphabetically.

also when you are querying the database you can use order by to sort your data alphabetically.

hope this helps.

Marian

skdzines

Thanks,

I tried the Order By before hand and it got rid of multiple songs. Meaning, I have in the database, three songs for the Foo Fighters. It should display them like this:

Foo Fighters: All My Life
Foo Fighters: Everlong
Foo Fighters: Times Like These

When I do the Order By it only displays Foo Fighters: All My Life and doesn't show the other 2.

Thanks for your help.

TheDefender

ORDER BY shouldn't do that. Are you sure you didn't do GROUP BY instead? That will do what you are describing, but ORDER BY shouldn't, because it does just what the name implies... it orders the results by whatever you tell it to.

marian

oh yeah i forgot use "group by"

ignore whatever is below, but if that doesn't work try whatever is below.

does it mean your data is stored like this in the database:

row1==>Foo Fighters: All My Life
row2==>Foo Fighters: Everlong
row3==>Foo Fighters: Times Like These

then i don't understand it is only showing just one record, are you sure you added:

"order by ASC" at the end of your query?

ok if it is not giving you the right results then grab all the data from the database and store it in an array like this, do not use order by in your query:

while()
{
$databaseValues[]=$row['songtitle']
}

after you have grabbed that use

$newVal=asort($databaseValues)

use a for loop like this:

for($i=0, $i<=sizeof($newVal); $i++)
{
echo $newVal[$i].'<br>';
}