SELECT only NOT NULL fields

[Anon]

Hello-
Been trying to find and easy answer to a problem that seems like it shouldn't be that hard. I want to display some results in an HTML table from a mysql table that has 50 fields. However, I want ONLY the fields that are not null to show up. So far I can only figure out how to either get the whole row, or predefined (or variable defined) fields.
If I try to do it less dynamically, I end up with a whole bunch of empty cells in my HTML table, and that of course looks stupid and causes endless scrolling for no reason. I guess what I'm asking, is "is there a way to filter the "SELECT * FROM" part of the query like you do the second part of the query (the "WHERE somefield IS NOT NULL).
I've though of some kind of "pull out the whole row as an array, loop through it, etc) but would hardly know where to start. I'm very willing to do my homework and put in the time, I'm just not sure where to go with this one.
Thanks for all your help- this site has been great.

-Jed R. Wood

[rrijnders]

SELECT * from your table and then use mysql_fetch_row() to get the row of data into an enumerated array. Then you can loop through the array elements checking each value to see if it is empty() or not. If it is not empty, output a table cell.

-- Rich