andyman
Joined: 25 Mar 2010
Posts: 1
Posted: 2010-03-25 01:22
Back to top
Reply with quote
|
I have a table where for various reasons there in an ' in the field content.
Eg O'Reilly as oppsed to O'Reilly
How do I adjust the out put so that it runs this code on the output string:
str_replace("'","'", $phpmyeditfield);
Thanks in advance!
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2010-03-27 14:48
Back to top
Reply with quote
|
It might make more sense to back up the table and then clean up the data by dumping a SQL query on phpMyAdmin.
| Code: |
| UPDATE `my_table` SET `my_field` = REPLACE(`my_field`, ''', "'"); |
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
