Re: Very Wierd Problem
| From: | John W. Holmes | Date: | Sat, 14 Jun 2003 15:31:00 +0000 |
| Subject: | Re: Very Wierd Problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-151485@lists.php.net to get a copy of this message | ||
James E Hicks III wrote:
I am experiencing some weird problems with PHP. When I execute the following
query from within a PHP script, the description is set to 'EBCO' and not
'EBCO\030774-006\BUBBLER VALVE'. When I execute this query from the mysql
monitor the value is inserted correctly.
$query = "update the_table
set description = 'EBCO\\030774-006\\BUBBLER VALVE'
where item_number = '1'";
mysql_query($query);
This statement prints to console incorrectly (notice funky character after
EBCO):
echo ("EBCO\030774-006\BUBBLER VALVE");
EBCO774-006\BUBBLER VALVE
\0 is a NULL character, IIRC. Either use single quotes:
echo ('EBCO\030774-006\BUBBLER VALVE');
or use two slashes, like you did above:
echo ("EBCO\\030774-006\\BUBBLER VALVE");
---John Holmes...