wanted a query to get only the field column from a table... have used "describe tablename" but it gives me all the columns.. i want only the field column from that
Not really sure but you could look at mysql_field_name() or mysql_fetch_field()
to use mysql_field_name() require to know the index
what do you mean by field colum
'Field' is the column in table which in a database
hm... OK, you have chosen a somewhat unlucky name for your colum, since field in itself is also the word to use for "colum". So,... is this waht you are looking for:
"select field from TABLE";
J.
pppppp wrote:wanted a query to get only the field column from a table...
wanted a query to get only the field column from a table...
U want to get only the fields name from your table or only one field name (how do u know witch one?) what exactly do u want?
Or u want like leatherback show u, how to extract all the records from one of the field?
want to get all the field names from table
Your signature is really appropriate. It is ALL in a word, and your words are not very clear. As we are trying to help you, and you are clearly not being clear on what you need, perhaps you could take the time to explain in more then 9 words what it is what you need.
for example : 'describe tablename' gives me total structure of the table in the database. but i want only to get the field names not the total description.
