Hi All,
There is no output, does somebody see something wrong because i cannot see it.
I think it should have to work, Many thanks
//********** Check if specific record exists ************
global $conn;
$strSQLExists = "SELECT * FROM orderunits where OrderID='5'";
$rsExists = db_query($strSQLExists,$conn);
$data=db_fetch_array($rsExists);
if($data)
{
header("Content-Type: text/xml");
$xmlBody = '<?xml version="1.0" encoding="ISO-8859-1"?>';
$xmlBody .= "<XML>";
$dynamicList = "";
while($row = db_fetch_array($data)){
$LineID = $row["id"];
$ProductID = $row["SKU"];
$Quantity = $row["Quantity"];
$CustomerOrderNr = $row["OrderID"];
$SalesPrice = $row["prize"];
$xmlBody .= '
<Detail>
<LineID>' . $LineID . '</LineID>
<ProductID>' . $ProductID . '</ProductID>
<Quantity>' . $Quantity . '</Quantity>
<CustomerOrderNr>' . $CustomerOrderNr . '</CustomerOrderNr>
<SalesPrice>' . $SalesPrice . '</SalesPrice>
</Detail>';
}
$xmlBody .= "</XML>";
echo $xmlBody;
$xmlBody->save("files/FWMS".$values["id"].".xml");
} else {
echo "Nothing!";
}