Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #11494

Re: how to change character to % character?

Show all headers | View raw

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.......

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

how to change character to % character? richard <noreply@example.com> - 2013-10-20 12:27 -0400
  Re: how to change character to % character? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2013-10-20 12:40 -0400
    Re: how to change character to % character? richard <noreply@example.com> - 2013-10-20 13:06 -0400
  Re: how to change character to % character? Evan Platt <evan@theobvious.espphotography.com.invalid> - 2013-10-20 09:45 -0700
    Re: how to change character to % character? richard <noreply@example.com> - 2013-10-20 13:04 -0400
      Re: how to change character to % character? Evan Platt <evan@theobvious.espphotography.com.invalid> - 2013-10-20 10:22 -0700
    Re: how to change character to % character? Jerry Stuckle <jstucklex@attglobal.net> - 2013-10-20 21:01 -0400
      Re: how to change character to % character? richard <noreply@example.com> - 2013-10-20 21:57 -0400
        Re: how to change character to % character? Jerry Stuckle <jstucklex@attglobal.net> - 2013-10-20 22:09 -0400
        Re: how to change character to % character? Evan Platt <evan@theobvious.espphotography.com.invalid> - 2013-10-20 23:18 -0700
          Re: how to change character to % character? Scott Johnson <noonehome@chalupasworld.com> - 2013-10-21 05:39 -0700
            Re: how to change character to % character? Evan Platt <evan@theobvious.espphotography.com.invalid> - 2013-10-21 06:31 -0700
  Re: how to change character to % character? Luuk <luuk@invalid.lan> - 2013-10-20 20:04 +0200
    Re: how to change character to % character? richard <noreply@example.com> - 2013-10-20 14:50 -0400
      Re: how to change character to % character? Jerry Stuckle <jstucklex@attglobal.net> - 2013-10-20 21:02 -0400
        Re: how to change character to % character? Arno Welzel <usenet@arnowelzel.de> - 2013-10-21 11:55 +0200
          Re: how to change character to % character? Jerry Stuckle <jstucklex@attglobal.net> - 2013-10-21 08:04 -0400
  solved! richard <noreply@example.com> - 2013-10-20 15:11 -0400
  Re: how to change character to % character? Arno Welzel <usenet@arnowelzel.de> - 2013-10-20 21:17 +0200
    Re: how to change character to % character? Luuk <luuk@invalid.lan> - 2013-10-20 21:50 +0200

csiph-web