| Re: how to change character to % character? [message #183367 is a reply to message #183353] |
Mon, 21 October 2013 09:55   |
Arno Welzel
Messages: 317
Registered: October 2011
Karma:
|
Senior Member |
|
|
Am 21.10.2013 03:02, schrieb Jerry Stuckle:
> On 10/20/2013 2:50 PM, richard wrote:
>> On Sun, 20 Oct 2013 20:04:54 +0200, Luuk wrote:
>>
>>> On 20-10-2013 18:27, richard wrote:
>>>> I noticed that whenever a song is clicked on that has an apostrophe in the
>>>> name, an error is now being generated.
>>>> The song still plays and the name is reported correctly.
>>>>
>>>> So how can I detect any and all 's within a string and convert them to the
>>>> %27 version?
>>>>
>>>> I had a look at preg-match and don't think that will help.
>>>>
>>>> www.mroldies.net/200/
>>>>
>>>>
>>>
>>>
>>> Why do i see this error:
>>> You have an error in your SQL syntax; check the manual that corresponds
>>> to your MySQL server version for the right syntax to use near 's Now Or
>>> Never ',' It's Now Or Never ',1) ON DUPLICATE KEY UPDATE hits=hits+1' at
>>> line 1
>>>
>>> on this link:
>>> http://www.mroldies.net/200/audiox1.php?play=6
>>>
>>> Can you not see that this is not a proper MySQL statement?
>>>
>>> Nut you better fix this now than never.......
>>
>> Precisely why I am asking how to fix.
>> The error stems from the fact that the echo statement "sees" a single quote
>> as part of the structure of the statement itself. NOT as a string.
>> IOW, "Hey stupid....your quotes don't match!"
>>
>> It is not a MYSQL problem. it is purely a syntax matter.
>>
>
> As you have been told MANY, MANY times before. You need to escape ALL
> of the strings you use when accessing ANY SQL database (not just MySQL).
Or just use prepared statements ;-)
--
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]