eof){ $Member_PKey = $DR1->field("PKey"); $strID = $DR1->field("strID"); $strPW = $DR1->field("strPW"); $strName = $DR1->field("strName"); $Member_Name = $DR1->field("strName"); $Company = $DR1->field("Company"); $EMail = $DR1->field("EMail"); $Tel = $DR1->field("Tel"); $Mobile = $DR1->field("Mobile"); $PostCode = $DR1->field("PostCode"); $Position = $DR1->field("Position"); $strCity = $DR1->field("strCity"); $Address = $DR1->field("Address"); if(chkDate($DR1->field("EndDate"))){ $EndDate = $DR1->field("EndDate"); }else{ $EndDate = add_date(date("y-m-d"),-10,0,0); } //取出剩餘次數 $sql = "Select Sum(Bonus) as Total from bonus Where datediff(EndDate,'".date("Y/m/d")."')>=0 and Member_PKey=".SqlFilter($Member_PKey,"int"); $rs = new recordset($sql); if (! $rs->eof){ $Member_bonus = $rs->field("Total"); } $SQL_U = "Update member Set Bonus=".$Member_bonus." Where PKey=".SqlFilter($Member_PKey,"int"); execute_sql($SQL_U); } ?>

歡迎使用本系統

姓名 *必填欄位
聯絡電話 *必填欄位
電子郵件
*必填欄位,請輸入有效的電子郵件!
聯絡地址
內容
*必填欄位,內容長度不得超過5000字!
驗證碼