[SOLVED]Referencing columns by number not name
Posted: Mon Oct 17, 2005 10:21 am
Quick question:
If you want to write a select statement for a table you don't know the column names for, how do you format the statement so that you use the column numbers, as you could with an array? The manual was a bit vague. So instead of writing
it would be more like
Thanks
If you want to write a select statement for a table you don't know the column names for, how do you format the statement so that you use the column numbers, as you could with an array? The manual was a bit vague. So instead of writing
Code: Select all
select * from tablename order by idCode: Select all
select * from tablename order by 0