0) {
while ($row = mysqli_fetch_assoc($result)) {
echo "
";
echo "
";
echo "
";
$sql2 = "SELECT DISTINCT productid FROM sparkling___products WHERE productsort = '" . $row["productsort"] . "' AND productquantity>0 ORDER BY `sparkling___products`.`productsort` ASC"; //查詢語句--查詢資料庫表
mysqli_query($conn, "SET CHARACTER SET UTF8");
$result2 = mysqli_query($conn, $sql2);
if (mysqli_num_rows($result2) > 0) {
while ($row2 = mysqli_fetch_assoc($result2)) {
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "";
echo "
" . $row2["productid"] . "
";
echo "
";
echo "";
echo "";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
}
} else {
echo "
目前無此類商品";
}
}
} else {
echo "
目前無此類商品";
}
}elseif ( $sort == 'news') {
echo "
";
echo "
";
$sql2 = "SELECT * FROM sparkling___storagechecking WHERE times > '2021/06/01' AND productquantity>0 "; //查詢語句--查詢資料庫表
mysqli_query($conn, "SET CHARACTER SET UTF8");
$result2 = mysqli_query($conn, $sql2);
if (mysqli_num_rows($result2) > 0) {
while ($row2 = mysqli_fetch_assoc($result2)) {
echo "
於" . $row2["times"] . "進。
";
}
} else {
echo "
目前無此類商品";
}
}else {
echo "
";
echo "
";
$sql2 = "SELECT DISTINCT productid FROM sparkling___products WHERE productsort = '" . $sort . "' AND productquantity>0 ORDER BY `sparkling___products`.`productsort` ASC"; //查詢語句--查詢資料庫表
mysqli_query($conn, "SET CHARACTER SET UTF8");
$result2 = mysqli_query($conn, $sql2);
if (mysqli_num_rows($result2) > 0) {
while ($row2 = mysqli_fetch_assoc($result2)) {
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "";
echo "
" . $row2["productid"] . "
";
echo "
";
echo "";
echo "";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
}
} else {
echo "
目前無此類商品";
}
}
mysqli_close($conn); //關閉資料庫
?>