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