Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Problem with Apostrophe in Data

Problem with Apostrophe in Data

Thread began 12/03/2012 7:18 am by Mike Perry | Last modified 12/03/2012 7:18 am by Mike Perry | 663 views | 0 replies |

12/03/2012 7:18 am | #1 Mike Perry

Problem with Apostrophe in Data

I'm running into a brick wall trying to get an apostrophe to output to a URL parameter.

Inherited a database that used apostrophes in several brand names. Want to use those brand names as a URL parameter; I've tried all the escape tricks I know, but the apostrophe and following letter won't show.

Example:

The brand name in the db is Mickelberry's. If I try to escape the apostrophe with a '\', the '\' shows in the URL, and the 's' doesn't.

Suggestions??

Thanks,

Mike

ETA: Disregard -- fixed it by swapping single and double quotes in the code. DUH!!!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.