Order by an unknow field name

[JRBeltman]

Hi,
I need to order my tables using a mysql query, but the field name by with to order can differ for each table.

So the query looks like:
select * from $table order by ?????

Is there something like order by COLUMN 0 or PRIMARY KEY?

Cheers

JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!

 

[JRBeltman]

Oh well,
found out why my idea did not work. The first column is no 1, not 0...

so "select * from $table order by 1" will order the table by the 1st column..

Cheers all

JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!