您現在的位置:
首頁 >
產品介紹 >
echo $title_main_name;?> - echo $title_sub_name;?>
//
//
//
//if($main_id=='' && $sub_id==''){
//
//
// $sql = "select id,pic from ".$sql_t."_product_main where states = 0 ";
// $sql .= "order by data_sort Limit 1";
// $rows = mysql_query( $sql);
// if (!$rows ) {
// echo $sql."SQL 指令錯誤!";
// exit;
// }
// if($row = mysql_fetch_row($rows)){
// $main_id = $row[0];
// $main_pic = $row[1];
// }
//
// $sql = "select id from ".$sql_t."_product_sub where states = 0 and main_id = '$main_id'";
// $sql .= "order by data_sort Limit 1";
// $rows = mysql_query( $sql);
// if (!$rows ) {
// echo $sql."SQL 指令錯誤!";
// exit;
// }
// if($row = mysql_fetch_row($rows)){
// $sub_id = $row[0];
// }
//
//}
$sql_main = "select pic from ".$sql_t."_product_main where states = 0 and id = '$main_id'";
//$sql_main .= "order by data_sort Limit 1";
$rows_main = mysql_query( $sql_main);
if (!$rows_main ) {
echo $sql_main."SQL 指令錯誤!";
exit;
}
if($row_main = mysql_fetch_row($rows_main)){
$main_pic = $row_main[0];
}
$sql_sub = "select pic from ".$sql_t."_product_sub where states = 0 and id = '$sub_id' ";
//$sql_sub .= "order by data_sort";
$rows_sub = mysql_query( $sql_sub);
if (!$rows_sub ) {
echo $sql_sub."SQL 指令錯誤!";
exit;
}
if($row_sub = mysql_fetch_row($rows_sub)){
$sub_pic = $row_sub[0];
}
$sql = "select * from ".$sql_t."_product where states = 0 ";
if($main_id != '' && $sub_id != '') {$sql .= " and main_id = '$main_id' and sub_id = '$sub_id' ";}
$sql .= "order by data_sort";
$rows = mysql_query( $sql);
if (!$rows ) {
echo $sql."SQL 指令錯誤!";
exit;
}
?>


while($row = mysql_fetch_array($rows)){?>
}?>