I would like to ask whether there is a way to get all columns ids (titles) of any table using sql commands in php ?

Thanks

Select column_name
from all_tab_columns
where table_name = 'tableA';

Thanks for reply
But this is not what i need to do :

I put my question in another way :
The only thing I have is the table name, and I want to get all its columns names.

Allow me to clarify.

THanks again
But this command doesn't execute :
My base is in a library called "revue" so for a normal request I type :

$sql= 'select * from revue.My_table "
$tab=executeSQL($sql)

Where execute Sql is a function that return a table tht contains the sql result.

To test your solution I typed :
$sql= "select column_name
from all_tab_columns
where table_name = 'revue.user'";

And it doesnt works : The error sais that "ALL_TAB_COLUMNS doesnt exists in revue"

Thans for your patience

Yes I see after you clarification
But considering this, my command I put above should work no ?

The solution I provided was for an Oracle database.

SQL Server:

Select column_name
from information_schema.columns
where table_name = 'tableA'

I'm using ibm database ( on a pc AS400 ) ... it must have clasic SQLs (87 and 91 (or 93 dont remember) )

Try:

describe table revue.My_table

error : The syntax element REVUE isn't correct

http://www-306.ibm.com/cgi-bin/db2ww...n0sqln0178.htm

Thanks a lot again
But I still get errors :[
I tried : describe table revue.user
describe select * from revue.user

This gives errors

: The syntax element "." isn't correct

I execute this command with "odbc_do" php function

It's dirty but might work in a pinch:
$sql= 'select * from revue.My_table where 1=0'
$tab=executeSQL($sql)

That way it would give an empty result set with the column info. Obviously the best solution is to find a way to get the schema of a table without running a query, but it might be harder in PHP since there is no result set object or anything to give you column information (you'll have to parse it yourself).

Yes this would work as I stand alone sql command but not with php for the reason you said

But thanks though Matt