| Re: solved [message #186090 is a reply to message #186086] |
Fri, 13 June 2014 18:43   |
Mr Oldies
Messages: 241
Registered: October 2013
Karma:
|
Senior Member |
|
|
On Fri, 13 Jun 2014 10:14:06 -0400, Jerry Stuckle wrote:
> On 6/13/2014 9:57 AM, richard wrote:
>> On Fri, 13 Jun 2014 00:57:10 -0400, richard wrote:
>>
>>> When attempting to transfer records from one table to another, certain
>>> records refuse to be.
>>> Such as those with words like "I'm".
>>> What's even more confusing is, "It's" won't work, but "Cathy's" is ok?
>>>
>>> I know there is a procedure in PHP for dealing with this.
>>> I just can't find it right now.
>>> Can anyone help on this?
>>
>> $a=str_replace("'","\'",$a);
>> Works just fine.
>> Thanks for the reminder tim.
>>
>
> That might work for sqllite, but it's definitely the WRONG way to do it
> in MySQL.
As you continously remind me, this is not an mysql issue.
The table data could care less what characters are in it.
mysqli doesn't give a shit either.
if I code the data with a \ in the column cell, the output will show that
\.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]