Re: [bug] WHERE thing != ''

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 --