Posted by Tommy Gildseth on 02/24/06 21:29

henshu wrote:

> I wonder if its possible to "extract"/copy/parse a specific line of xml
> from my mySQL table - isolate it from the rest of the mysql entry (on
> PHP display)?
>
> example (as mySQL see's it):
> "Today is sunny <img src="/pictures/sun.gif" /> with chances of rain
> <img src="/pictures/raincloud.jpg" width="50" alt="rain" title="rain" />
> this evening. So you may want to carry your umbrella on your way to work."
>
> isolated out to:
> <img src="/pictures/sun.gif" /><img src="/pictures/raincloud.jpg"
> width="50" alt="rain" title="rain" />

I do not believe that will be possible using only SQL, and I'm not even sure
it's adviseable.
You will probably need to do some post processing with PHP. It can probably
be done using regex, or you can use XML DOM functions to parse the XML, and
extract all the child nodes using for ex. XPATH.

--
Tommy
http://design.twobarks.com/

• Next in forum: Re: Joining many results from one table with one result from another in one query
• Prev in forum: Re: Joining many results from one table with one result from another in one query
• Thread view: Re: help - isolate specific xml from mySQL entry?

[Reply to this message]