i'm trying to get the name of fields from a table. Is there any sql query for this activity ? thank you
It depends on the database that you are using.
The most common form is 'desc tablename' which will work for both Oracle and MySQL;
Sorry don't now about Postgres or MSSQL
how about to get these names stored on the result set, as well as when we use select .... query on php.