Sort by alphabet instead of nr?

I have a link script that displays all links based on link nr instead of alphabet.
Every time I add a link, in the mysql database the link gets a nr and when it is displayed it will show the links based on those nrs. So the first link entered will be on top and then the second link entered and so on.

What php command needs to be used to have the links sorted by alphabet?

 

IMO, you should sort them with MySQL (or whatever DB you're using) and not PHP. Maybe you could post the actual SQL statement and someone can help you get it "sorted" out.

Bobby

 

Use this:

SELECT * FROM `tablename` ORDER BY `linkname` DESC

It orders your links by their name...

 

That's if you want it to go from Z - A...

Replace DESC with ASC if you want it to go from A - Z

 

Thank you

This was exactly what I was looking for