/* 上一个商品下一个商品 */
" T- B2 a, U- G! c# t1 k6 T        $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");# i6 S3 G3 g2 z3 m
        if (!empty($prev_gid))
6 o2 ~+ r3 E; U$ ?        {
( V' m/ D1 P/ _" q4 f            $prev_good['url'] = build_uri('goods', array('gid' => $prev_gid), $goods['goods_name']);
1 o! c4 w+ m5 A5 A- z/ q1 r5 J            $smarty->assign('prev_good', $prev_good);//上一个商品' R# J: W) t8 n: i3 q
        }

        $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");: x* x6 R0 H- X# B0 W- _
        if (!empty($next_gid))1 k1 {0 z& J4 X, l+ t: r( Y9 h
        {
. ^' \0 _0 V6 }            $next_good['url'] = build_uri('goods', array('gid' => $next_gid), $goods['goods_name']);* J7 G& n  _' b+ a
            $smarty->assign('next_good', $next_good);//下一个商品8 T" t$ G5 M+ X; ]* V
        }

/* 上一个商品下一个商品 */ * v' q, f- m0 o$ m$ ?. T% U5 T
$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");
' z3 `! o& b2 l  V  |        if (!empty($prev_gid))
5 _7 D& }# i- u        {
' b2 Z& P5 B& C  O- h. v# h            $prev_good['url'] = build_uri('goods', array('gid' => $prev_gid['goods_id']), $goods['goods_name']);
0 t+ J$ Y, ~7 t5 l            $prev_good['goods_name'] =$prev_gid['goods_name'];- [4 p  ?6 G2 B# {' z
            $smarty->assign('prev_good', $prev_good);//上一个商品5 N! O  s$ b$ |0 L
        }

        $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");( L) u1 C6 k: X, \# w
        if (!empty($next_gid))
# g: n0 |( S# [2 O( a8 |        {; y: N/ ^/ ?+ s: E
            $next_good['url'] = build_uri('goods', array('gid' => $next_gid['goods_id']), $goods['goods_name']);! A4 m& y& T; Y7 q4 b( B3 ?
            $next_good['goods_name'] =$next_gid['goods_name'];( N8 R  O3 t1 |( C$ F2 V. x2 M
            $smarty->assign('next_good', $next_good);//下一个商品
  B% A8 `0 N# e. \0 o) D9 @        }