read from sql and output xml

nkm5009

ok. i know this is possible, but i just keep messing it up. what i am trying to do is read data from mysql with php. i however, what that php file to generate xml so that it can be read into flash. make sense. i want to do what is in this tutorial, but more to it. www.creativecow.net/articles/brimelow_lee/php_mysql/php_mysql_flash.html. in that tutorial the xml looks something like this
<products>
<item></item>
<products>

and it tells you how to do that. however, i want mine to have more nodes to it. like this

i hope this makes sense to everyone. i really want to get this accomplished. or if you know another way to put data from mysql into flash, that would be awesome too. thank you in advance for your responses.

nick

NogDog

Here's a function slightly modified from a method I use in my MySQL class that might give you some ideas:

   function getXml($queryResult)
   {
      mysql_data_seek($queryResult, 0);
      $xml = "<"."?xml version='1.0' encoding='ISO-8859-1'?".">\n<data>\n";
      $count = 1;
      while($row = mysql_fetch_assoc($queryResult))
      {
         $xml .= "  <record row='$count'>\n";
         foreach($row as $key => $val)
         {
            $xml .= "    <$key>$val</$key>\n";
         }
         $xml .= "  </record>\n";
         $count++;
      }
      $xml .= "</data>";
      return($xml);
   }  // end getXml()

nkm5009

i don't understand where the strings are getting defined at. can you please help me. i am new to php as well, so it doesn't make complete sense to me. thanks for the code though.

nick