Column Names on a report

[jawa]

I've got a script that will allow a user to choose any number of the fields in the table, or all of them if they want. I'm dynamically building the sql to go fetch the data.

In my experience with SQL, you can return the answer set, but not column titles...but my experience is somewhat limited.

Is there a way to return the field names in a header without having to dynamically build it?

My results are being output to HTML.

Thanks!
-J

[stolzyboy]

Not exactly certain what you are trying to do, but I think this will get you headed in the right direction: http://www.php.net/manual/en/function.mysql-field-name.php