Selecting only populated columns in MySQL

[kid A]

Hey, still learning here ..

How would I go about it if I were to display a row from my table, but exclude the columns that were NULL? I also want to find out if a column has a value, and return a result(0 or 1) but not the contents.

I've fiddled around with it a bit, but cant really work it out.

Also, how do I get PHP to parse HTML tags stored in my db (in a TEXT column)?

Thanks again