$sql .= $sqlOrder;
$cGoods->resultSQL($sql);
?>
<input type="submit" value="変更" size="120px" >
<input type="hidden" name="retrievalKey" value="<?php
echo $key;
?>
">
</form>
<div id="goodsList">
<h2>商品一覧リスト</h2>
<?php
// 商品名検索表示と通常表示処理
if ($key == '') {
goodsListview($cGoods->get_gTable(), $itemCount, $cID, $Order);
} else {
goodsListview($cGoods->Retrieval($key), $itemCount, $cID, $Order);
}
// アイテムが何も無い時の処理
if ($cGoods->get_row_g() == 0) {
echo "<br>このカテゴリーに登録された商品は、ありません。";
}
?>
</div>
</div>
<div id="leftside" >
<div id="loginForm">
<h3>USERMENU</h3>
retrievalForm_head();
?>
<?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">