Sort array

[stonehall]

I would really appreciate some help on this.

I do a SQL query and normally just do a "while ($data = mysql_fetch_array($sql))" and echo the output.

What I want to do now is to sort the array before outputting the data, to get it in the correct order. I cannot just sort the data in the SQL query as I have to sort a column containing data in the format of "Firstname1 Lastname1 and Firstname2 Lastname2" and the sorting for that column has to be sorted by Lastname1 ASC.

I figure this is somehow done using a sort array command but I am very lost on how to do achieve this sorting.

// Andreas

[Litewebsite]

If you would like sort an array there are some functions for this

• natcasesort - Sort an array using a case insensitive "natural order" algorithm
• natsort - Sort an array using a "natural order" algorithm

There are more array sorting methods too: php array functions

Hope this can help you