List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 23 1999 4:03pm
Subject:Re: SELECT * WHERE NULL
View as plain text  
At 8:31 AM -0500 8/23/99, Lawrence Blades wrote:
>How can I select ALL columns that are NULL without having to specify
>each column name, ie, using the asterix?
>
>Like,  "select * from tablename where ????? is null"
>
>I want to use mysql_fetch_array and only print the columns that are not
>null.
>I then pass them as variables in form inputs. But I don't want the null
>columns to show up.


You'll have to do the work yourself.  Sorry.
Fetch the values, then test them yourself.  You'll have to look at them
individually anyway in order to put them in the proper place within the
form, won't you?

-- 
Paul DuBois, paul@stripped
Thread
SELECT * WHERE NULLLawrence Blades23 Aug
  • SELECT * WHERE NULLsinisa23 Aug
  • Re: SELECT * WHERE NULLPaul DuBois23 Aug