|
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.inc.php");
/*
$connect = new MysqlConnect();
$connect->host = $host;
$connect->username = $username;
$connect->password = $password;
$connect->connect($dbname);
*/
$sql = "select yy from vardata group by yy order by yy ";
$result = mysql_query($sql);
$aarr = array();
while ($arr = mysql_fetch_array($result)) {
//echo $arr[yy]."<br>";
$aarr[] = $arr[yy];
}
$unarr = array_unique($aarr);
sort($unarr);
echo "<?xml version='1.0' encoding='tis-620'?>";
echo "<yymm>";
// Fix year 2547
//echo "<yy val='2547'>";
//echo "<mm label='12' val='12'/>";
//echo "</yy>";
/////////////////////////////////////////////////////////////////////////
for($iarr = 0;$iarr<count($unarr);$iarr++){
echo "<yy val='";
echo $unarr [$iarr]."'>";
$valsql = "select mm from vardata where yy='".$unarr [$iarr]."' group by yy order by yy";
$valresult = mysql_query($valsql);
$valarr = array();
while($varr = mysql_fetch_array($valresult)){
$valarr[] = $varr['mm'];
}
$unvalarr = array_unique($valarr);
sort($unvalarr);
for($ival=0;$ival<count($unvalarr);$ival++){
echo "<mm label='".($unvalarr[$ival]+3)."' val='";
echo $unvalarr[$ival]."'/>";
}
echo "</yy>";
}
echo "</yymm>";
?>