Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 12-16-2011, 08:25 PM   PM User | #1
Blackwoods
New to the CF scene

 
Join Date: Dec 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Blackwoods is an unknown quantity at this point
Hyperlinks within Longtext Fields

I was running on MySQL 4.1 and recently upgraded to 5.1.
In some of my db fields I have always had hyperlinks to other related pages, etc. as a dynamic footer.

Today I updated some of the basic text in the field and all the links returned with a \ before each "

For example: "http://www.site.com/otherpage"

is now: \"www.site.com/otherpage\"

Basically breaking all the code in the field.

Is there a setting I have changed by accident? Or an alternative way using phpMyAdmin to remove these \\ from the field when saving.

Thanks for any suggestions...
Blackwoods is offline   Reply With Quote
Old 12-16-2011, 09:09 PM   PM User | #2
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,548
Thanks: 62
Thanked 4,054 Times in 4,023 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
Must be something phpMyAdmin is doing. MySQL wouldn't do that to you by itself. Time to investigate the settings in phpMyAdmin, perhaps??
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is online now   Reply With Quote
Old 12-16-2011, 09:46 PM   PM User | #3
Blackwoods
New to the CF scene

 
Join Date: Dec 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Blackwoods is an unknown quantity at this point
Thanks. I am racking my brain looking through My PHP documentation and I simply cant find this behavior anywhere I look. Something is definitely awry.
Blackwoods is offline   Reply With Quote
Reply

Bookmarks

Tags
field inserts, mysql

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 10:03 PM.


Advertisement
Log in to turn off these ads.