PHP->XML help

[ParkerDigital]

I'm using a PHP script to pull data from a MySQL database, and then output it as XML in order to send it to a Flash movie. It's a script I've used before without any problems, but this time I must have done something wrong somewhere, as when I test it in IE I get a message saying "The XML page cannot be displayed". Here's the code:

        print '<?xml version="1.0"?>
    <!DOCTYPE jobads[
    <!ELEMENT jobads (jobad)>
    <!ELEMENT jobad (id, jobtitle, salary, location)>
    <!ELEMENT id (#PCDATA)>
    <!ELEMENT jobtitle (#PCDATA)>
    <!ELEMENT salary (#PCDATA)>
    <!ELEMENT location (#PCDATA)>
    ]>

<jobads>';
        
        while ( $r1 = mysql_fetch_array($q) ) {
            print '<jobad>';
            print '<id>'.$r1['id'].'</id>';
            print '<jobtitle>'.$r1['jobTitle'].'</jobtitle>';
            print '<salary>'.$r1['salary'].'</salary>';
            print '<location>'.$r1['location'].'</location>';
            print '</jobad>';
            }
        
        print '</jobads>';

I've left out the SQL code as I know that there's no problem in getting the data from the database. I'm guessing that the problem is with the XML output. Anyone have any ideas?

[partyman]

What does firefox say when try to view it? Can you view what it's outputting? (ie the raw code)

[ParkerDigital]

partyman, In Firefox it's displayed like this

]> 10Marketing Assistant£16,000Mold, North Wales8Accounts Manager£22,000Ormskirk7Web Designer£18,000Ormskirk9Airline Pilot£45,000Manchester11Treasurer£28,000Birmingham

...which is essentially the data from the database, with the last bracket from the XML DTD at the beginning. In the past I've had similar scripts that displayed in a similar way in Firefox, and worked fine when I parsed them in Flash. It's just that normally they display OK in IE and don't give me any error messages.

[partyman]

You may need to put in:

header('Content-Type: text/xml');

[ParkerDigital]

You may need to put in:

header('Content-Type: text/xml');

Great - that works fine in Firefox now. Still get the error code in IE, but if Firefox says it's OK, that's good enough for me!

Cheers

[hxbro]

for one of my flash things I use the following:

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<screenshots>\n";
while ($row = mysql_fetch_array($result))
{
?>
    <screenshot caption="<?php echo rawurlencode($row['description'] . "<br><br>Click for more information") ?>" productid="<?php echo $row['product_id'] ?>" id="<?php echo $row['id'] ?>" />
<?
}
?>
</screenshots>

try remove the doctype.

Also in flash dont forget to tell it to ignore the white space by doing

xmlDoc.ignoreWhite = true;

[hxbro]

also make sure things are proper html e.g. £ shouldn't be £, try htmlspecialchars($r1['salary'])

[ParkerDigital]

also make sure things are proper html e.g. £ shouldn't be £, try htmlspecialchars($r1['salary'])

Thanks for that. Oh, and the whitespace thing. I had to find out about that one the hard way - hours and hours of wondering why my trace command was bringing up "undefined" for my parsed data

[hxbro]

got me too, spent a week wondering why it didn't work