ecshop商品上一个下一个改为产品名称的方法

/* 上一个商品下一个商品 */
$prev_gid = $db->getOne(“SELECT goods_id FROM ” .$ecs->table(‘goods’). ” WHERE cat_id=” . $goods['cat_id'] . ” AND goods_id > ” . $goods['goods_id'] . ” AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 LIMIT 1″);
if (!empty($prev_gid))
{
$prev_good['url'] = build_uri(‘goods’, array(‘gid’ => $prev_gid), $goods['goods_name']);
$smarty->assign(‘prev_good’, $prev_good);//上一个商品
}
$next_gid = $db->getOne(“SELECT max(goods_id) FROM ” . $ecs->table(‘goods’) . ” WHERE cat_id=”.$goods['cat_id'].” AND goods_id < “.$goods['goods_id'] . ” AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0″);
if (!empty($next_gid))
{
$next_good['url'] = build_uri(‘goods’, array(‘gid’ => $next_gid), $goods['goods_name']);
$smarty->assign(‘next_good’, $next_good);//下一个商品
}

/* 上一个商品下一个商品 */
$prev_gid = $db->getRow(“SELECT goods_id,goods_name FROM ” .$ecs->table(‘goods’). ” WHERE cat_id=” . $goods['cat_id'] . ” AND goods_id > ” . $goods['goods_id'] . ” AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 LIMIT 1″);
if (!empty($prev_gid))
{
$prev_good['url'] = build_uri(‘goods’, array(‘gid’ => $prev_gid['goods_id']), $goods['goods_name']);
$prev_good['goods_name'] =$prev_gid['goods_name'];
$smarty->assign(‘prev_good’, $prev_good);//上一个商品
}
$next_gid = $db->getRow(“SELECT goods_id,goods_name FROM ” . $ecs->table(‘goods’) . ” WHERE cat_id=”.$goods['cat_id'].” AND goods_id < “.$goods['goods_id'] . ” AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 order by goods_id desc limit 1″);
if (!empty($next_gid))
{
$next_good['url'] = build_uri(‘goods’, array(‘gid’ => $next_gid['goods_id']), $goods['goods_name']);
$next_good['goods_name'] =$next_gid['goods_name'];
$smarty->assign(‘next_good’, $next_good);//下一个商品
}

<a href=”{$prev_good.url}”><img alt=”prev” src=”./images/up.gif” /></a>

<a href=”{$prev_good.url}”>{$prev_good.goods_name}</a>

<a href=”{$next_good.url}”><img alt=”next” src=”./images/down.gif” /></a>

<a href=”{$next_good.url}”>{$next_good.goods_name}</a>