[SOLVED] XML file works if I don't use a query

[brooksh]

I can't seem to figure this out. If I manually input the image source it works, but if I use a query it errors out. In the header I am using:

header("Content-type: text/xml");
echo '<?xml version="1.0" encoding="UTF-8"?>';

 

In the content I have

<image source="house.jpg" title="Front view" description=""/>

But if I use this query instead it doesn't work. I have verified that the query is good.

 

<?
$result = mysql_query("SELECT DISTINCT name,caption,description,rank FROM images WHERE id = '$id' ORDER BY rank");
while($row = mysql_fetch_array($result)){
?>
<image source="<?=$row[file_name]?>" title="<?=$row[caption]?>" description="<?=$row[description]?>" />
<?
}
?>

[PugJr]

Don't you have to have the $row[file_name] and the others as $row['file_name']? I remember having that problem awhile ago.

 

Try adding the single quotes.

[brooksh]

no quotes, single quotes and double quotes doesn't matter.

[PugJr]

Wait, what exactly isn't working? Get an mysql error or the content just won't show up?

[brooksh]

The query works. When I call the xml file and manually input the info, the pictures show up, but if I use a query it doesn't work. When looking at the xml file, they look identical.

 

Manual:

<image source="image18.jpg" title="test" description=""/>

sql query:

<image source="image14.jpg" title="Front view" description=""/>

[priti]

are you trying to insert image tag in XML ???

[brooksh]

Yes I am adding an image tag in an php xml file. Named xml.php with specialized headers. It works if I manually input the data, but if I call it through a query it doesn't and I have verified several times that the query works.

[haku]

The closing xml tag will close your php tags. Change this:

echo '<?xml version="1.0" encoding="UTF-8"?>';

to this:

?>
<?xml version="1.0" encoding="UTF-8"?>
<?php

[haku]

I should also mention that the image tag attribute is not 'source', it's 'src'.

[brooksh]

I'm going to have to disagree with you haku.

 
<?php
header("Content-type: text/xml");
echo '<?xml version="1.0" encoding="UTF-8"?>';
?>

This works just fine as a php file. The way this script is used, it is actually called as source, not src. Like I mentioned before, it works fine if I manually input

<image source="image18.jpg" title="test" description=""/>

[brooksh]

It was supposed to be

 

echo '<?xml version="1.0" encoding="UTF-8"?>';

[priti]

keep <image source="image18.jpg" title="test" description=""/> in CDATA Tag and try Might be your

 

'<' and '>' is getting parsed

 

<![CDATA[<image source="image18.jpg" title="test" description=""/>]]>

[haku]

Feel free to not learn from my mistakes all you want. But the mistake I have made in the past was that the closing xml tag closed off my php tag.

[brooksh]

It was worth a shot but <![CDATA]]> didn't work.

 

Haku. How is this closing my xml tag? I did try what you said, but it just gave me errors because I want it to echo

<?xml version="1.0" encoding="UTF-8"?> and if I close it off with a single quote I can echo it. I reads just fine if I view source.

echo '<?xml version="1.0" encoding="UTF-8"?>';

I have used this exact header in different php xml files.