/* 上一个商品下一个商品 *// W3 C  a8 u0 L" Q$ t6 g3 A( E
        $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");
8 C) g' S# ?# j# z        if (!empty($prev_gid))
4 U! i8 C9 E% M2 }& J- @+ p- G4 Q* n        {) E& [" a# J/ D8 \$ _1 X
            $prev_good['url'] = build_uri('goods', array('gid' => $prev_gid), $goods['goods_name']);5 r( }+ B) [7 x. J3 S$ {
            $smarty->assign('prev_good', $prev_good);//上一个商品
8 F, M" M5 y; V) h1 E; v, ?        }

        $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");5 D+ y7 p1 c: V. T- G  i
        if (!empty($next_gid)); W& j1 H( V/ w* z
        {6 |6 G4 O% G9 A
            $next_good['url'] = build_uri('goods', array('gid' => $next_gid), $goods['goods_name']);+ u1 B) X  l$ w$ O6 v, D% |: S
            $smarty->assign('next_good', $next_good);//下一个商品& z# r+ `7 L' H9 K
        }

/* 上一个商品下一个商品 */ # d8 G8 Y" F; I3 x# ~  F+ ~
$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");
1 X) Y! ~  d; J7 ^& N) ~0 I$ B        if (!empty($prev_gid))# e5 b' T4 X3 I) K; f$ s1 o
        {
5 i0 i; r( I3 I% B            $prev_good['url'] = build_uri('goods', array('gid' => $prev_gid['goods_id']), $goods['goods_name']);, y, B$ ~' @! `7 L
            $prev_good['goods_name'] =$prev_gid['goods_name'];
8 X/ e( u/ g: b$ {1 T% N            $smarty->assign('prev_good', $prev_good);//上一个商品
7 a5 ?: h3 A& C2 q, a        }

        $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");% f4 |6 @6 V& M! L$ u
        if (!empty($next_gid))
. i$ ?" u- y2 a# u7 ?+ P3 V; @        {
7 l% q7 x7 R& q, H! _, C3 ]            $next_good['url'] = build_uri('goods', array('gid' => $next_gid['goods_id']), $goods['goods_name']);
& i+ y9 G* X8 B2 ?7 k/ c            $next_good['goods_name'] =$next_gid['goods_name'];1 ]* m  m0 ~& v2 q$ r0 T
            $smarty->assign('next_good', $next_good);//下一个商品
" a* q& P6 k8 W% x        }