Ordering by 2 Values, Possible?

[UG_Nikon]

Im trying to order by 2 values:
example: When you have standings, and yo uwant to order by points and then by Goals For.
so you do .... ORDER BY P, PF

Why doesnt this work? I'v tried severela different ways but Iv never figured it out.

Thanks,
Nikon

[jeremuck]

did you read the documentation?
http://www.mysql.com/doc/en/SELECT.html
ORDER BY P,PF

I find back-ticks help sometimes.

[[deleted]]

"Why doesnt this work? I'v tried severela different ways but Iv never figured it out. "

Care to tell us what is going wrong?
Is it not odering the way you expected?
Are you sure the fields are of a numeric type, and not a VARCHAR type?

Backticks should only 'help' when the fieldnames are something exotic that could be mis-interpreted, normally you won't need them.

[UG_Nikon]

I figured it out:
I basically had to do this: ORDER BY 'Points' DESC, 'ROUNDS FOR' DESC")

I had to specify both DESC's for it to properly order, I would only specify 1 before.

Thanks for the help guys.

Nikon