Click to See Complete Forum and Search --> : Selecting only populated columns in MySQL


kid A
05-03-2003, 02:45 PM
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

kid A
05-03-2003, 04:31 PM
Doh!

Nevermind, I worked it out. :)