Get Column Names AND Data 1

[jammer1221]

Hi all,

I was having some trouble with this one, and was wondering if anyone had an easy answer.

I'm trying to get all the column names in a row. And then get the data for each row. I can do both of these seperatly.

The problem I am having is that I need to check whether or not the column has data in it for that row and if not I need to not include it, into the output varible.

I don't know if this has a blindingly simple answer, or if its impossible but I've been working on it forever. Sorry if the above is a little confusing, I tried to explain it the best I could. Well thanks for the help in advance.

Matt

 

[jammer1221]

Oh ya, this is all in a MySql database...Left that out, it might help.

 

[sleipnir214]

mysql_fetch_assoc() fetches data from a MySQL result handle into an associative array. There's column names and values all at once.

If you want to get all the columnnames first, issue a DESCRIBE tablename query and fetch the results of that query. This will give all the information you will ever need about your table, and you can follow that query with a SELECT query.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[jammer1221]

Hey sleipnir,

Thanks for the help I got on the right track with your post. I didn't know/think about a "Describe

" query.

Thanks again,
Matt