I have a table with this fields:

team
games
won
draw
lost
goals2
points

Now I want to order the results by points goals and games.
I tryed but nothing is showing up.
Somebody please can help me.

you would do something like this,

SELECT * FROM table_name ORDER BY points

change table_name with what ever your name of the table is

add ASC if you want the points listed in Ascending order or add DESC if you wanna list them in Descending order.

Phil

Ordering by point is not the problem... I try to ordering by points and games and goals

I think you can only order by one order at a time, not sure u can do multiple order bys

In which point, i would make 3 seperate pages, with each query on, having links to each page to display the querys.

Apart from that, i cant be much more help,

Phil

try this:

SELECT * FROM table_name ORDER BY field1,field2,field3 DESC

.. well now i'm getting my results in line but ASC....???

this is what i code


SELECT * FROM matrix ORDER BY points,goals,games DESC

Each of the order by fields can be either ASC or DESC. ASC is the default, so your querySELECT * FROM matrix ORDER BY points,goals,games DESC

would be interpreted by the database as:

SELECT * FROM matrix
ORDER BY
points ASC,
goals ASC,
games DESC

I guess what you want is:

SELECT * FROM matrix
ORDER BY
points DESC,
goals DESC,
games DESC

HTH,

foogee