// 取出此產品的類別 BEGIN $SQLStr = "SELECT c_id FROM product WHERE p_id='$p_id'"; $res = db_query($SQLStr); $row = db_fetch_array($res); // 取出此產品的類別 END // 將 c_id 參數指定為此一產品的類別 $c_id = $row['c_id']; // 取出 product 及 class JOIN 過後的資料 BEGIN $SQLStr = "SELECT product.*, class.* FROM product AS product "; $SQLStr .= "LEFT JOIN class AS class ON product.c_id = class.c_id WHERE product.c_id='$c_id'"; $res_all = db_query($SQLStr); // 取出 product 及 class JOIN 過後的資料 END ?>
| 其他產品 |
| " . $row_all['p_name'] . " - NT$" . $row_all['p_price'] . " |