Posted by henshu on 02/24/06 20:29

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" />


In this example I'm trying to make a PHP file that isolates and displays
only the img src tags, ignoring the text spiel attached to it. Of course
I can get the whole entry from mySQL to pop-up in the PHP (all the
regular text + the images), but I have yet to figure out a way just to
have the images showing (since they share the same mySQL table, I can't
isolate it normally as if it were 2 different columns/tables).

• 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: help - isolate specific xml from mySQL entry?

[Reply to this message]