= 0){
}else{
$st=0;
}
//受け取った変数等の初期化
if(ereg("[0-9]+", $en)){
}else{
$en=5;
}
if(ereg("[0-9]+", $sort)){
}else{
$sort=1;
}
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 coukameisysno,coutimest,coukameicod ,tiknam,katennam,jyannam,coukeititle ";
$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 and coukeiflg=TRUE ";
$sql=$sql . " and coustaymd <= CURRENT_DATE and couendymd >= CURRENT_DATE ";
$sql=$sql . "order by coutimest DESC ";
//SQL実行
$pgex = gpg_exec($pgcn, $sql, basename(__FILE__),__LINE__);
$kensu = $en - $st - 1;
?>
クーポン一覧
pg_numrows($pgex)){ $endjyo=pg_numrows($pgex);}else{$endjyo=$st+$en;}
for ($i=$st; ($i<$endjyo); $i++) {
?>
次の件
前の件
ﾄｯﾌﾟ