php抽獎程式 亂數隨機抽獎

index.php： <form id="form1" name="form1" method="post" action=""> 總數： <input type="text" name="total" id="total" /> <br /> 筆數： <input...

閱讀更多

"你是獵人還是獵物？"

資料庫 SQL WHERE BETWEEEN ID 語法

SELECT * FROM shop2 WHERE (p_open = 'Y') and (shop_id between 1 and 3)  ORDER BY p_date DESC 從shop2資料表選取全部資料，且符合產品資料開放及產品分類id介於1～3之間的產品，依照日期遞減。 SELECT * FROM shop2 WHERE (p_open = 'Y') and (shop_id in (1,3,5))  ORDER BY p_date DESC 從shop2資料表選取全部資料，且符合產品資料開放及產品分類id在（1,3,5）的產品，依照日期遞減。 SELECT * FROM shop2 WHERE (p_open = 'Y') and (shop_id >=1 and shop_id<=5)  ORDER BY p_date DESC 從shop2資料表選取全部資料，且符合產品資料開放及產品分類id介於1～5之間的產品，依照日期遞減。 SELECT * FROM shop2 WHERE (p_open = 'Y') and (shop_id in (1,3,5)) AND (shop_id !=5)  ORDER...

閱讀更多

"你是獵人還是獵物？"