for experiment i pull data from mysql to xml to use in flash how can i add ahref to id in xml to achieve like this
http://www.kalitekolik.x10.mx/product.php?id=1
http://www.kalitekolik.x10.mx/PHP_MySQL_Flash_FINISHED.swf
my database like this
id/ product_name/ price/ details
<?PHP
$link = mysql_connect("localhost","lafamosa_kermis","lafamosa1000");
mysql_select_db("lafamosa");
$query = 'SELECT * FROM products';
$results = mysql_query($query);
echo "<?xml version=\"1.0\"?>\n";
echo "<products>\n";
while($line = mysql_fetch_assoc($results)) {
echo "<item>" . $line["id"] . "</item>\n";
echo "<item>" . $line["product_name"] . "</item>\n";
echo "<item>" . $line["price"] . "</item>\n";
}
echo "</products>\n";
mysql_close($link);
?>