Re: [PHP] NULLS vs Empty result in PHP

2009-09-23 Thread Bastien Koert
On Wed, Sep 23, 2009 at 11:35 AM, Philip Thompson wrote: > On Sep 23, 2009, at 9:48 AM, Dan Shirah wrote: > >>> >>> From reading the other responses to this thread, it seems that you want >>> to >>> "skip" or "exclude" rows in the results where my_column === null. >>> >>> If this is correct, why n

Re: [PHP] NULLS vs Empty result in PHP

2009-09-23 Thread Philip Thompson
On Sep 23, 2009, at 9:48 AM, Dan Shirah wrote: From reading the other responses to this thread, it seems that you want to "skip" or "exclude" rows in the results where my_column === null. If this is correct, why not do it in the SELECT statement to begin with? $my_query = "SELECT my_col

Re: [PHP] NULLS vs Empty result in PHP

2009-09-23 Thread Dan Shirah
> > From reading the other responses to this thread, it seems that you want > to > "skip" or "exclude" rows in the results where my_column === null. > > If this is correct, why not do it in the SELECT statement to begin with? > > $my_query = "SELECT my_column FROM my_database WHERE my_column IS NO

Re: [PHP] NULLS vs Empty result in PHP

2009-09-23 Thread Jim Lucas
Dan Shirah wrote: > Morning! > > Just a quick question. > > Say I have a column in my database that could contain NULLS, empty spaces, > or an actual value. > > If I do: > > $my_query = "SELECT my_column FROM my_database WHERE 1 = 1"; > $my_result = ifx_query($my_query, $connect_id); > > while

RE: [PHP] NULLS vs Empty result in PHP

2009-09-23 Thread Samrat Kar
Use var_dump before processing your result. Regards, Samrat Kar FRD, BARC Tel: 022-25597295 Alternate Email: esam...@yahoo.com -Original Message- From: Dan Shirah [mailto:mrsqua...@gmail.com] Sent: Wednesday, September 23, 2009 5:28 PM To: PHP General Subject: [PHP] NULLS vs Empty res