include ("php/common.bas");
include ("php/pgsql.bas");
include ("php/global.conf");
//データベース接続
gpg_connect(basename(__FILE__),__LINE__);
//$sql="select * from kyufile,tikmst where tikcod=kentikucod order by kyutimesta DESC";
$sql="";
$sql=$sql . "select katyoumei,couhyojiadd,coupcsetumei,kahyojiadd,coukameisysno,coutimest,coukameicod ,tiknam,katennam,jyannam ";
$sql=$sql . "from kameimst,tikmst,jyanmst,couponfile ";
$sql=$sql . "where jyankatecod=kakatecod and jyansubcod=kasubcod and jyancod=kajyancod ";
$sql=$sql . " and katikcod=tikcod and kacod=coukameicod ";
$sql=$sql . " and coustaymd <= CURRENT_DATE and couendymd >= CURRENT_DATE and kakoukaikbn=TRUE ";
$sql=$sql . "order by coutimest DESC ";
//SQL実行
$pgex = gpg_exec($pgcn, $sql, basename(__FILE__),__LINE__);
?>