num_rows) {
$row = mysqli_fetch_assoc($rst);
$s_title = $row['f_title'];
}
mysqli_free_result($rst);
}
unset($where, $order, $sql, $pageMovePara);
CDC();
?>
- All
num_rows) {
while ($row = mysqli_fetch_assoc($rst)) {
$pageMovePara = "?s_ref=$s_ref&s_ref_2=$row[f_uid]";
?>
num_rows) {
?>
num_rows) {
$where_d1 = [];
while ($row = mysqli_fetch_assoc($rst)) {
array_push($where_d1, $row['f_uid']);;
}
$where_r1 = " and ( ";
for ($i = 0; $i < count($where_d1); $i++) {
if ($i == count($where_d1) - 1) {
$where_r1 .= " (f_ref = '$where_d1[$i]') ";
} else {
$where_r1 .= " (f_ref = '$where_d1[$i]') or ";
}
}
$where_r1 .= " ) ";
}
mysqli_free_result($rst);
}
unset($where, $order, $sql, $pageMovePara);
CDC();
}
$where = "t_product where f_div = 'product_$langCheck' and f_show_yn = 'Y' $where_r1 ";
$where .= $s_ref_2 ? " and f_ref = '$s_ref_2' " : null;
$where .= $s_ref_3 ? " and f_ref_2 = '$s_ref_3' " : null;
$order = " ORDER BY f_ref asc, f_ref_2 asc, f_sort+0 DESC, f_uid DESC ";
$sql = "SELECT * from $where $order ";
if ($rst = mysqli_query(CTD(), $sql)) {
if ($rst->num_rows) {
while ($row = mysqli_fetch_assoc($rst)) {
$pageMovePara = "?s_ref=$s_ref&s_ref_2=$row[f_ref]&s_ref_3=$row[f_ref_2]&s_uid=$row[f_uid]";
?>
-
![<?= $row['f_filename_0'] ?>](../../upload/product/<?= $row['f_file_0'] ?>)