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
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?
"...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and
Dave J. Hala Jr.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php