something wrong..

[Ulitasch]

I want to integrate following php-file into my Flash-movie, but something still
does not work.
The Php-file is like that:


Online it looks like that:
[url]http://www.ulla.nl/henri_ritzen/input.php[/url]

Thankx for any tips !!!


<?php

header("Content-type: text/xml");

$host = "localhost";
$user = "username";
$pass = "password";
$database = "db";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to
host.");
mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM home LIMIT 0, 9";
$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output .= "<rss version=\"2.0\">\n";
$xml_output .= "<channel>\n";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
$row = mysql_fetch_assoc($resultID);
$xml_output .= "<item>\n";
$xml_output .= "<idder>" . $row['id'] . "</idder>\n";
$xml_output .= "<title>" . $row['title'] . "</title>\n";
$xml_output .= "<link>http://ulla.nl/henri_ritzen/content.php?id=" .
$row['id'] . "&amp;expandable=" . $row['menuLink'] . "</link>\n";
$xml_output .= "<enclosure url='images/" . $row['doc'] . "' type='" .
$row['ext'] . "'/>\n";
$xml_output .= "</item>\n";
}

$xml_output .= "</channel>\n";
$xml_output .= "</rss>";

echo $xml_output;

?>

[Ulitasch]

with this code (without database) it works...

<rss version="2.0">
<channel>
<item>
<idder>0207</idder>
<title>1 project benaming</title>
<link>http://www.klebowax.com</link>
<enclosure url='images/video.flv' type='flash/flv' />
</item>
<item>
<idder>0207</idder>
<title>2 project benaming</title>
<link>klebowax.com</link>
<enclosure url='images/video.flv' type='flash/flv'/>
</item>
<item>
<idder>0207</idder>
<title>3 news items</title>
<link>klebowax.com</link>
<enclosure url='news/news_01.swf' type='flash/swf' />
</item>
</channel>
</rss>