Hi all. I use the interaction with PHP, and i have some problem. How i can use the statement between, with the fields in Flash?
He create the xml perfect, but in the values (09/10/2005 and 10/10/2005) i need the fields of Flash.
My code is.
<?php
//Include database variables
include_once("inc_sql.php");
//Connect to database
$connect = mysql_connect(HOSTNAME, USERNAME, PASSWORD);
mysql_select_db(DATABASE, $connect);
//Query the database
$result = mysql_query("select * from ag_expedicao where emissao between '09/10/2005' and '10/10/2005'");
//And now we need to output an XML document
//We use the names of columns as <row> propertys
echo '<?xml version="1.0" encoding="UTF-8"?>';
echo '<datapacket>';
while($row=mysql_fetch_array($result)){
$line = '<row Id="'.$row[Id].'" fatura="'.$row[fatura].'" emissao="'.$row[emissao].'" pedido="'.$row[pedido].'" ean="'.$row[ean].'" produto="'.$row[produto].'" qtd="'.$row[qtd].'" datas="'.$row[datas].'" uf="'.$row[uf].'"/>';
echo $line;
}
echo '</datapacket>';
?>
Tanks.