$product_no=$_GET["product_no"];?> include "db_connect.inc"; if($product_no==""){ $query = " select count(*) as pcount ". " from product_table a,product_category_table b ". " where a.view_kbn='1' ". " and b.view_kbn='1' ". " and a.language='1' ". " and b.language='1' ". " and a.category_no=b.category_no "; $result = mysql_query($query); $rc = mysql_fetch_object($result); if(intval($rc->pcount)==0){ header("Location: product_technology.php"); }elseif(intval($rc->pcount)==1){ $query2 = " select a.product_no ". " from product_table a,product_category_table b ". " where a.view_kbn='1' ". " and b.view_kbn='1' ". " and a.language='1' ". " and b.language='1' ". " and a.category_no=b.category_no "; $result2 = mysql_query($query2); $rc2 = mysql_fetch_object($result2); header("Location: product.php?product_no=".$rc2->product_no); }else{ $query2 = " select category_no,category,date_format(insert_date,'%Y/%m/%d') as insert_date2,date_format(update_date,'%Y/%m/%d') as update_date2 ". " from product_category_table ". " where view_kbn='1' ". " and language='1' ". " order by jyunban "; $result2 = mysql_query($query2); $query3 = " select * ". " from product_table ". " where view_kbn='1' ". " and language='1' ". " order by category_no,jyunban "; $result3 = mysql_query($query3); if(mysql_num_rows($result3)>=0){ while($rc3=mysql_fetch_object($result3)){ $count[$rc3->category_no]=intval($count[$rc3->category_no])+1; $product_no[$rc3->category_no][$count[$rc3->category_no]]=$rc3->product_no; $product_name[$rc3->category_no][$count[$rc3->category_no]]=$rc3->product_name; $model_name[$rc3->category_no][$count[$rc3->category_no]]=$rc3->model_name; $price[$rc3->category_no][$count[$rc3->category_no]]=$rc3->price; $open_price[$rc3->category_no][$count[$rc3->category_no]]=$rc3->open_price; $image_m[$rc3->category_no][$count[$rc3->category_no]]=$rc3->image_m; $explanation[$rc3->category_no][$count[$rc3->category_no]]=$rc3->explanation; } } ?> $page_title="商品について - 株式会社ドリームクリエーション"?> $pan_list="> 商品について"?>
");else print("");?>商品トップ | content1_name!="" && $rc->content1_view=="1"){?>");else print("");?>",$rc->content1_name))?> | }?> content2_name!="" && $rc->content2_view=="1"){?>");else print("");?>",$rc->content2_name))?> | }?> content3_name!="" && $rc->content3_view=="1"){?>");else print("");?>",$rc->content3_name))?> | }?> content4_name!="" && $rc->content4_view=="1"){?>");else print("");?>",$rc->content4_name))?> | }?> content5_name!="" && $rc->content5_view=="1"){?>");else print("");?>",$rc->content5_name))?> | }?> content6_name!="" && $rc->content6_view=="1"){?>");else print("");?>",$rc->content6_name))?> | }?> content7_name!="" && $rc->content7_view=="1"){?>");else print("");?>",$rc->content7_name))?> | }?> content8_name!="" && $rc->content8_view=="1"){?>");else print("");?>",$rc->content8_name))?> | }?> content9_name!="" && $rc->content9_view=="1"){?>");else print("");?>",$rc->content9_name))?> | }?>}?> |
"> | content1_name!="" && $rc->content1_view=="1"){?>"> | }?> content2_name!="" && $rc->content2_view=="1"){?>"> | }?> content3_name!="" && $rc->content3_view=="1"){?>"> | }?> content4_name!="" && $rc->content4_view=="1"){?>"> | }?> content5_name!="" && $rc->content5_view=="1"){?>"> | }?> content6_name!="" && $rc->content6_view=="1"){?>"> | }?> content7_name!="" && $rc->content7_view=="1"){?>"> | }?> content8_name!="" && $rc->content8_view=="1"){?>"> | }?> content9_name!="" && $rc->content9_view=="1"){?>"> | }?>}?> |
if($content_no==1)print("".strip_tags($rc->content1_name).""); if($content_no==2)print("".strip_tags($rc->content2_name).""); if($content_no==3)print("".strip_tags($rc->content3_name).""); if($content_no==4)print("".strip_tags($rc->content4_name).""); if($content_no==5)print("".strip_tags($rc->content5_name).""); if($content_no==6)print("".strip_tags($rc->content6_name).""); if($content_no==7)print("".strip_tags($rc->content7_name).""); if($content_no==8)print("".strip_tags($rc->content8_name).""); if($content_no==9)print("".strip_tags($rc->content9_name).""); ?> |
|