<?php

include_once "header.php";

include_once "../function.php";

global $xoopsDB,$xoopsModule;

$sql= "select `v_cate`, sum(`v_money`) sum_money 

from `".$xoopsDB->prefix("ben_sv_stored_value")."` 

where month(`v_svdate`) <= '2' 

group by `v_cate`

order by `v_cate` ASC

 ";

$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());

if(!$result){

  echo "查無資料";

}else{

  echo "有資料";

  while($all = $xoopsDB->fetchArray($result))

  {

  //以下會產生這些變數： $v_cate, $sum_money

  foreach($all as $k=>$v){

  $$k=$v;

  }

      echo  $v_cate.": 累計總計:".$sum_money."<br>";

  }

}

?>