Get all columns in a table

[nesvarbu]

I want to retrieve all columns that are in particular table.I dont want to get the values of the columns but the column names themselves.

Lets say:

<?php mysql_query("SELECT * FROM tablename"); ?>

is no good

I need smth like "SELECT all column names FROM tablename";

[bad76]

Hi,
look at mysql_list_fields() function.

It give you all the information you need.

[leatherback]

How about

mysql_list_fields()

J.

[nesvarbu]

can you give me an example, couse I have problems in oputputing those columns.....

[leatherback]

Hi,

How about you have a look at the manual, Your Best Friend: There is an example there. If that doesn't work. Please post the your code, and the problem you have.

J.