<?php
headerBar_head();
?>
</div>
<div id="main">
<div id="content">
<div class="goodsInfo" >
<h2>商品情報</h2>
<?php
// 受け取ったgoodsidのデータだけを取得するSQL
$sql = "SELECT * FROM goods, categories, makers " . " WHERE goods.makerID = makers.makerID and " . " goods.categoryID = categories.categoryID and " . " goods.goodsid= '{$goodsid}'";
$cGoods->resultSQL($sql);
goodsInfo($cGoods->get_gTable());
// 受け取ったgoodsid以外で同一categoryidデータを取得するSQL
$sql = "SELECT * FROM goods, categories, makers " . " WHERE goods.makerID = makers.makerID and " . " goods.categoryID = categories.categoryID and " . " goods.goodsID != '" . $goodsid . "' and " . " goods.categoryID = '" . $cGoods->get_gCid(0) . "'";
$cGoods->resultSQL($sql);
?>
</div>
<div class="clear"></div>
<div class="goodsMatchcategory">
<h2>おすすめ商品</h2>
<?php
goodsMatchcategory($cGoods->get_gTable(), $cGoods->get_row_g());
?>
</div>
</div>
<div id="leftside" >
<div id="loginForm">
<h3>USERMENU</h3>
<?php
