DJ Unique Posted January 29, 2008 Share Posted January 29, 2008 Hi, I need some help finding and replacing content from a field in a mssql database. I have a mssql database called mp3_players. I have a column called web_content and in that column I have loads of XML text. Basically, I have the following XML stored in the web_content column: <text id="0" guid="997ba35c-6a7a-4578-8076-2140b3c9e834" name="Description"><![CDATA[Apple iPod]]></text> I want to be able to search web_content for the above line and store everything from name=" to </text> in a PHP variable. Then extract the description, whatever it might be, in this case its an Apple iPod, and store that as a separate variable. Then I want to replace the description with another variable that might be something like Apple iPod 80GB. Any suggestions on how I can do this? Quote Link to comment https://forums.phpfreaks.com/topic/88368-phpmssql-find-and-replace-help/ Share on other sites More sharing options...
rajivgonsalves Posted January 29, 2008 Share Posted January 29, 2008 have you written any code till now if so please post it I can modify it... Quote Link to comment https://forums.phpfreaks.com/topic/88368-phpmssql-find-and-replace-help/#findComment-452263 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.