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

This query returns 0 rows. (no error messages either) But when I execute
the query: 
SELECT id,PVLN from lhpl_side WHERE PVLN ="\Z"; from the mysql command
prompt it works properly. (returns a 172 rows)

I realize that I need to do an update to change the value in field.
However, right now I just need to get a query that works to the db.

Anyone got any ideas?

:) Dave

"...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and
the Ugly)"

Dave J. Hala Jr.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to