order from greatest to least

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dsick
Forum Commoner
Posts: 57
Joined: Fri Mar 27, 2009 3:34 pm

order from greatest to least

Post by dsick »

i have a table called views in my users table.....
i want the highest number of views to be placed at the top


i have a chart position on my site and it will be determined by a number of things like highest views(unique views)highest ranking, number of comments ect, it will be broken down into different categories of criteria... all im wanting to know how to do is order data from least to greatest inside of my database....
dsick
Forum Commoner
Posts: 57
Joined: Fri Mar 27, 2009 3:34 pm

Re: order from greatest to least

Post by dsick »

figured it out my self, i am going to use some appregate functions
Post Reply