Select Column Name based on a Query

[beckjoh]

I am trying to export column names and data from a mysql table into a csv file.  I can do that just fine, however sometimes (if no data is present) one or more of my columns will have zeros placed into the rows.  This is how I programmed it to work.  However, now I want to export only the columns that do not have the zeros.  In other words, I want to only export the columns and data that are valid.  Can anyone point me into the right direction.

Thanks

 

JB

[fenway]

I'm not sure I follow -- just limit your export.

[beckjoh]

Sorry I was not very clears.  Let say I have a table like this:

 

Column 1 | Column 2 | Column 3

 

    89              0            99

    88              0            98

    76              0            98

 

Then I would like the csv file to look like this:

 

Column 1 | Column 3

 

    89              99

    88              98

    76              98

 

Thanks

 

 

[fenway]

You'll need to check the value for Col2 across all rows before you write the CSV.