I have a problem hopefully somebody can help me out with. I am using serialize to store an array in MySQL. One of the values this array is 18" Franco Chain Necklace. What happens is that before it is inserted and I write unserialize($myArray) to the page there is an escape slash in front, so it reads like

a:1:{i:0;a:10:{s:7:"iItemID";i:5;s:8:"ItemName";s: 28:"Assemble your Spur & Rowel ©";s:12:"Descriptions";s:86:"18\" Franco Chain Necklace, 6pt_yg_stone

Now when this value is pulled from MySQL it is stripping the escape slash and will not return the array correctly.

a:1:{i:0;a:10:{s:7:"iItemID";i:5;s:8:"ItemName";s: 28:"Assemble your Spur & Rowel ©";s:12:"Descriptions";s:86:"18" Franco Chain Necklace, 6pt_yg_stone

I know this is the problem because I can update the DB and it works correctly. My question is how can I prevent MySQL from removing my slash. When I insert I am just using
serialize($arrAssemblyCart) I have tried serveral things but none of them work.

mike

__________________
Peace
Mike
http://www.eclecticpixel.com

Hi,

I think “Serialization in Database” article on
http://aspalliance.com/1093_Serializ...n_Database.all may be helpful in this discussion.

This popular white paper is written by a software engineer from our organization Mindfire Solutions (http://www.mindfiresolutions.com).

I hope you find it useful!

Cheers,
Byapti