[PHP] Re: \Z characters
Dave J. Hala Jr. [EMAIL PROTECTED] ha scritto nel messaggio 1040500684.942.130.camel@badboy">news:1040500684.942.130.camel@badboy... I've got a bunch of fields in a mysql database that have a \Z character in them. I want to search a field for \Z and if it contains that character, make the field blank. In running php 4.x on RH 8.0 Here is the code: $connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN =\\\Z\ ; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); You are looking for a field that is a string and consist of a \Z character! not more not less. I don't understand if this is what you want or you want to find all fields that CONTAIN a \Z in any position. In this case the correct query would be select id,PVLN from lhpl_side WHERE PVLN LIKE \%\\Z\% mATTIA cAZZOLA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: \Z characters
This field contains ONLY the \Z. Thanks for the suggestion but it generates the following error message: Parse error: parse error, unexpected '\' in On Sun, 2002-12-22 at 04:49, Mattia wrote: Dave J. Hala Jr. [EMAIL PROTECTED] ha scritto nel messaggio 1040500684.942.130.camel@badboy">news:1040500684.942.130.camel@badboy... I've got a bunch of fields in a mysql database that have a \Z character in them. I want to search a field for \Z and if it contains that character, make the field blank. In running php 4.x on RH 8.0 Here is the code: $connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN =\\\Z\ ; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); You are looking for a field that is a string and consist of a \Z character! not more not less. I don't understand if this is what you want or you want to find all fields that CONTAIN a \Z in any position. In this case the correct query would be select id,PVLN from lhpl_side WHERE PVLN LIKE \%\\Z\% mATTIA cAZZOLA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: \Z characters
On Sunday 22 December 2002 22:14, Dave J. Hala Jr. wrote: This field contains ONLY the \Z. Thanks for the suggestion but it generates the following error message: Parse error: parse error, unexpected '\' in On Sun, 2002-12-22 at 04:49, Mattia wrote: Dave J. Hala Jr. [EMAIL PROTECTED] ha scritto nel messaggio 1040500684.942.130.camel@badboy">news:1040500684.942.130.camel@badboy... I've got a bunch of fields in a mysql database that have a \Z character in them. I want to search a field for \Z and if it contains that character, make the field blank. In running php 4.x on RH 8.0 Here is the code: $connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN =\\\Z\ ; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); You are looking for a field that is a string and consist of a \Z character! not more not less. I don't understand if this is what you want or you want to find all fields that CONTAIN a \Z in any position. In this case the correct query would be select id,PVLN from lhpl_side WHERE PVLN LIKE \%\\Z\% Try: $SQL = SELECT id,PVLN from lhpl_side WHERE PVLN = '\\Z'; -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Someone else stole your IP address, call the Internet detectives! */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: \Z characters
$connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN =\\\Z\ ; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); Not too sure on this, but it might solve the problem. Use single quotes instead... $connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN ='\Z'; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); -- Kyle Gibson admin(at)frozenonline.com http://www.frozenonline.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php