Steve Cayford [EMAIL PROTECTED] on 25/09/2001 17:28:57
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] Getting my head around nulls
On Tuesday, September 25, 2001, at 10:30 AM, [EMAIL PROTECTED]
wrote:
Just had a look at manual, ifnull() seems
On Wednesday, September 26, 2001, at 02:48 AM, [EMAIL PROTECTED]
wrote:
Steve Cayford [EMAIL PROTECTED] on 25/09/2001 17:28:57
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] Getting my head around nulls
On Tuesday, September 25, 2001
I wish the rest of the world saw it that way! But not so...
That's what capitalism does for you -;)
You may want to look at MySQL's IS_NULL function for retrieving data.
Other
than that, I don't have any good advice. It seems that if you retrieve a
NULL from the database and try to assign it to
my head around nulls.
I wish the rest of the world saw it that way! But not so...
That's what capitalism does for you -;)
You may want to look at MySQL's IS_NULL function for retrieving data.
Other
than that, I don't have any good advice. It seems that if you retrieve a
NULL from
SELECT * from some_table WHERE some_field IS NULL;
Andrey Hristov
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
Thanks for
Just realised, you meant 'is null' not is_null. Sorry, couldn't see the
wood for the trees. This in ANSI SQL and I use it every day.
Had a look at zootweb.com. And I thought ASP meant 'Active Server Pages'
not 'Application Service Provider'. And not a zoot suit in sight -;)
Regards,
Neb
Thanks for correcting my misspelling, Andrey, IS NULL not IS_NULL.
Another thing to look at, Ben, is IFNULL(). I would give you an example,
but
I never got it to work like I thought it should ;) I think it is supposed
to
return an alternate value for NULLs.
Just had a look at manual, ifnull()
On Tuesday, September 25, 2001, at 10:30 AM, [EMAIL PROTECTED]
wrote:
Thanks for correcting my misspelling, Andrey, IS NULL not IS_NULL.
Another thing to look at, Ben, is IFNULL(). I would give you an
example,
but
I never got it to work like I thought it should ;) I think it is
And remember 0 as a number is as important as any other number.
I wish the rest of the world saw it that way! But not so...
You may want to look at MySQL's IS_NULL function for retrieving data. Other
than that, I don't have any good advice. It seems that if you retrieve a
NULL from the
9 matches
Mail list logo