maybe someone can help me with this.
I have rows in a table called “shows” in my database. I want to Flash to show and order that entire table.
so I made this PHP script:
<?php
$connection=mysql_connect(“localhost”, “user”, “password”);
mysql_select_db(user, $connection) or die(‘Could not select table’);
$result = mysql_query(“SELECT * FROM shows ORDER BY timestamp ASC”);
echo "<?xml version="1.0"?>
";
echo "<shows>
";
while($r=mysql_fetch_array($result)) {
$date = $r[‘timestamp’];
$day = date(“l m/d/Y”,$date);
$city = $r[‘city’];
$state = $r[‘state’];
$venue = $r[‘venue’];
$bands = nl2br($r[‘bands’]);
$time = $r[‘time’];
$cost = $r[‘cost’];
echo "<each>
$day<br />$city, $state<br />@ $venue<br />$bands<br />$time - $cost<br /><br />
</each>
";
}
echo "</shows>
";
mysql_close();
?>
I uploaded that PHP file, checked it out, and it worked. So I viewed the source and glad to see this:
<?xml version=“1.0”?>
<shows>
<each>
Thursday 12/22/2005<br />Denver, CO<br />@ Rex<br />Me<br />
First STrickekl<br />
Heck!<br />4:00 - $30<br /><br />
</each>
<each>
Monday 12/26/2005<br />Fargo, ND<br />@ Georg’es<br />band1<br />
band2<br />
band3<br />
band4<br />4:00 - $20<br /><br />
</each>
</shows>
so far so good. that means my PHP script successfully pulled the rows
out of the table I selected, and formatted it in XML.
My problem is that I can’t load it in flash.
here is my actionscript:
shows = new XML();
shows.ignoreWhite = true;
shows.load(‘http://www.watchyouburn.com/projects/test.php’);
shows.onLoad = function() {
XMLOut(this);
};
function XMLOut(xml_file) {
for (a=0; a<xml_file.firstChild.childNodes.length; a++) {
for (z=0; z<xml_file.firstChild.firstChild.childNodes.length; z++) {
lister.htmlText = (xml_file.firstChild.childNodes[a].childNodes[z].firstChild.nodeValue);
}
}
}
“lister” being the dynamic text field that I would like my information to show up in.
when I test the movie…the text field just says “undefined”.
I’m stuck.
any help would be appreciated.
