[PHP-DB] Re: retrieving special characters from MySQL

2001-07-23 Thread Steve Brett

pull it out then use stripslashes() as you display it ...

Steve

Andrew [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Hi, I'm having trouble getting special characters out of MySQL using php
 4.06.

 I add a field like McDonald's from PHP and in mysql client I can see the
 entry (McDonald's) is put into the database correctly. However the problem
 arises when I query it and it prints out (McDonald\'s). Is there any way
for
 php to pull out the string as it is in the database without putting in the
 escape character ( \ )  

 thx





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] Re: retrieving special characters from MySQL

2001-07-23 Thread Andrew

THX to everyone for the help!!!


Steve Brett [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 pull it out then use stripslashes() as you display it ...

 Steve

 Andrew [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  Hi, I'm having trouble getting special characters out of MySQL using php
  4.06.
 
  I add a field like McDonald's from PHP and in mysql client I can see
the
  entry (McDonald's) is put into the database correctly. However the
problem
  arises when I query it and it prints out (McDonald\'s). Is there any way
 for
  php to pull out the string as it is in the database without putting in
the
  escape character ( \ )  
 
  thx
 
 





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]