echoing url to xml output

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I am creating an XML output using php but get a error because the data
in the description field is outputing a link which is: <a HREF="HTTP://
WWW.PASTETHEWALL.CO.UK">Paste the wall</A>.

Below is the script I'm using, new to php and not sure how to get
round this hope someone can help. Thanks in advance..........

$dbhost = '';
$dbuser = '';
$dbpass = '';
$dbname = '';
mysql_connect($dbhost, $dbuser, $dbpass) or die("I could not connect
to database");
mysql_select_db($dbname) or die (mysql_error());
header('Content-type: text/xml');
echo '<?xml version='1.0' encoding='UTF-8'?>';
echo '
<products xmlns:xsi=" "
// Start the XML
$data = mysql_query("select * from products ORDER BY description");
while($row = mysql_fetch_array($data))
echo '
<product id="'.$row['description'].'">
echo '

Re: echoing url to xml output wrote:
Quoted text here. Click to load it


You get an error.
What error?
In PHP or with the xml-output when you try to parse it somewhere else?

A blind guess would be: You get an error in the produced XML, since it  

<product id="'.$row['description'].'">

which gives:

<product id="<a HREF="HTTP://WWW.PASTETHEWALL.CO.UK ">Paste the wall</A>">

That doesn't make a lot of sense.
It is a very strange id: "<a HREF="

Then follows immediately:
HTTP://WWW.PASTETHEWALL.CO.UK ">Paste the wall</A>"

I don't know the first thing about XML, but I expect this to be nonsense.

If an id in XML is anything like an id in html, it cannot contain  
spaces, or <

Erwin Moller

Quoted text here. Click to load it

Re: echoing url to xml output

it wrote:

Quoted text here. Click to load it

echo '
<product id="'.htmlentities($row['description']).'">

Also, for what it's worth...

Quoted text here. Click to load it

select description from products ORDER BY description

ought to be faster.

Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux, up 12 days, 20:36.]

                      Sharing Music with Apple iTunes

Site Timeline