Jump to content


Photo

Alphabetically list data?


  • Please log in to reply
2 replies to this topic

#1 Nothadoth

Nothadoth
  • Members
  • PipPipPip
  • Advanced Member
  • 119 posts

Posted 16 August 2006 - 12:03 AM

At the moment I have the information from my database listed by the ID. However I need it to be listed by the names alphabetically. How do I do this?

ORDER BY name ...


Thank you

#2 hostfreak

hostfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 581 posts

Posted 16 August 2006 - 12:05 AM

How about:

ORDER BY name ASC


#3 Nothadoth

Nothadoth
  • Members
  • PipPipPip
  • Advanced Member
  • 119 posts

Posted 16 August 2006 - 12:06 AM

Thank you =]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users