PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: question on null or 0
[EMAIL PROTECTED] wrote:
> Why not use the following SELECT statement:
> select col1 from jenny where col1<>0 and col1 is not null
>
> That should do the trick nicely. :)
>
> Gordon
[EMAIL PROTECTED] wrote:
> Why not use the following SELECT statement:
> select col1 from jenny where col1<>0 and col1 is not null
>
> That should do the trick nicely. :)
>
> Gordon Dewis
what if 0 *is* a valid entry for that particular row?
chris
--
---
Just
simple fix:
while( ($col1) = $sth_1->fetchrow_array){
because $sth_1->fetchrow_array returns an array, $col1 needs to be part
of a list context.
On Wed, 2002-10-16 at 13:10, Liu, Jenny wrote:
>
>
> The following simple sql statement just try to select a column from a table.
> But if the val
[EMAIL PROTECTED]]
Sent: October 16, 2002 13:10
To: [EMAIL PROTECTED]
Subject: FW: question on null or 0
The following simple sql statement just try to select a column from a table.
But if the value is 0 or null, the row will not be printed. Is there any
way I can make all the rows printed? The col
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 16 October 2002 20:10, Liu, Jenny wrote:
> The following simple sql statement just try to select a column from a
> table. But if the value is 0 or null, the row will not be printed.
> Is there any way I can make all the rows printed? Th
The following simple sql statement just try to select a column from a table.
But if the value is 0 or null, the row will not be printed. Is there any
way I can make all the rows printed? The col1 is a integer data type in
table.
Thanks
$Sql_stmt = "select col1 from jenny ";
