Re: Access to a Database

[Thimble Smith]

On Tue, May 04, 1999 at 03:00:09PM +0200, Daniel Lacal wrote:
>           $sql="select * from usuarios where email !=null";

Agckhhh!  Don't try that.  Use "IS NOT NULL" instead.  Or better
yet, make the column NOT NULL in your CREATE TABLE statement and
then say "WHERE email <> ''" in your code.  No, they aren't the
same thing.  But you aren't being careful with NULL values, so
it'd be better for your programs if you don't use them anywhere!

Please, everyone, NULL and = don't mix!

Tim