<?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