| Re: how to change character to % character? [message #183330 is a reply to message #183319] |
Sun, 20 October 2013 18:04   |
Luuk
Messages: 329
Registered: September 2010
Karma:
|
Senior Member |
|
|
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.......
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]