More Website Templates @ TemplateMonster.com - November 11, 2013!
coupons
"; $sql = "SELECT `優惠券總表`.`券號`, `優惠券總表`.`券名`, `優惠券總表`.`折數`, `類表`.`類名` FROM `類表`, `優惠券總表`, `會員名單` Where (`優惠券總表`.`類號`=`類表`.`類號`) And (`優惠券總表`.`擁有者會號` = `會員名單`.`會號`) And (`會員名單`.`會員帳號` ='$id')"; $result = mysql_query($sql); if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; } else{ echo "
| 優惠卷編號 | "; echo "優惠券名稱 | "; echo "折數 | "; echo "商品分類 | "; echo "
|---|---|---|---|
| $row[0] | "; echo "$row[1] | "; echo "$row[2] | "; echo "$row[3] | "; echo "
