|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_vc/report/sar/ |
Upload File : |
<?
//require_once("../../inc/conndb.inc.php");
require_once("../../inc/conndb_nonsession.inc.php");
echo "<?xml version='1.0' encoding='tis-620'?>";
echo "<yymm>";
$sql = "select distinct yy from vardata group by yy order by yy ";
$result = mysql_query($sql);
$aarr = array();
while ($arr = mysql_fetch_array($result)) {
echo "<yy val='$arr[yy]'>";
$valsql = "select distinct mm from vardata where yy='$arr[yy]' order by mm";
$valresult = mysql_query($valsql);
while($varr = mysql_fetch_array($valresult)){
echo "<mm label='".($varr[mm]+3)."' val='" . $varr[mm]."'/>";
}
echo "</yy>";
}
echo "</yymm>";
?>