Ordering mysql

[solex]

hi, can i use mysql commands in php to out put sorted from eg 0-100 in a collom.

thanx in advance

solex

 

[KarveR]

If I understand you correctly then :
yes.

Otherwise pass.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[solex]

how?

solex

 

[hos2]

have you already the values in a table ??

select * from table order by fieldname
is the way how you order you're values

 

[solex]

so:

"SELECT * FROM users ORDER BY score"

would out put from highest "score" to smallest "score" rows?

thanx

solex

 

[hos2]

perhaps it's then

"SELECT * FROM users ORDER BY score DESC"


DESC=descending
ASC=ascending

 

[solex]

aaa, great, thanx both.

solex

 

[natefanaro]

"SELECT * FROM users ORDER BY score"

Is good but I'm not sure what way it will be ordered. I usually specify ASC (ascending - lowest to highest) and DESC (descending - highest to lowest) to determine the order. so it would look like

"SELECT * FROM users ORDER BY score ASC"

 

[natefanaro]

Sorry, didn't mean to post an answer to a question that has been answered. hos2 posts quicker than I do I should learn to make my answers shorter

 

[solex]

thnx any way

solex

 

[jstreich]

If left off, DESC or ASC the default will be ASC... per SQL standards.