Re: [bug] WHERE thing != ''

!= works fine in MySQL. AFAIK, it is the exact same as <> where MySQL is concerned...there is something else going on here. --Joey Smith Please forgive the long sig: *** Notice To Bulk Emailers: Attention! Pursuant to US Code, Title 47, Chapter 5, Subchapter II, 227, any & all unsolicited commercial e-mail sent to this address is subject to a download and archival fee in the amount of the $1500 US and copies will be forwarded to domain administrators. Emailing denotes acceptance of said terms! On 29 May 2000, Manuel Lemos wrote: > Precedence: bulk > > Hello Yann, > > On 29-May-00 19:30:27, you wrote: > > >There is a very unpleasant bug in the release version of PHP4.0.0. > >It seems it is new, because my programs worked perfectly well with the RC2. > > >A simple code like this (where "thing" is a varchar(255) in MySQL) : > > >$result=mysql_query("SELECT thing FROM test WHERE thing != ''"); > > >produces a segmentation fault in apache 1.3.12 under RedHat Linux 6.2. > >Haven't tried any other OS. > > >So it is not possible to select a non-empty string with the new release... > > SQL is not C or PHP . In SQL different is <>, not != . > > > Regards, > Manuel Lemos > > Web Programming Components using PHP Classes. > Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org > -- > E-mail: mlemos@acm.org > URL: http://www.mlemos.e-na.net/ > PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp > -- > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >