Re: [PHP] Getting my head around nulls

2001-09-26 Thread Ben . Edwards
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

Re: [PHP] Getting my head around nulls

2001-09-26 Thread Steve Cayford
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

RE: [PHP] Getting my head around nulls.

2001-09-25 Thread Ben . Edwards
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

Re: [PHP] Getting my head around nulls.

2001-09-25 Thread Andrey Hristov
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

RE: [PHP] Getting my head around nulls.

2001-09-25 Thread Johnson, Kirk
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

RE: [PHP] Getting my head around nulls.

2001-09-25 Thread Ben . Edwards
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

RE: [PHP] Getting my head around nulls

2001-09-25 Thread Ben . Edwards
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()

Re: [PHP] Getting my head around nulls

2001-09-25 Thread Steve Cayford
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

RE: [PHP] Getting my head around nulls.

2001-09-24 Thread Johnson, Kirk
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