| Re: how to change character to % character? [message #183334 is a reply to message #183330] |
Sun, 20 October 2013 18:50   |
Mr Oldies
Messages: 241
Registered: October 2013
Karma:
|
Senior Member |
|
|
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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]