/* 上一个商品下一个商品 */
" }6 _% T# f, a        $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");
0 V5 C6 O3 t6 ~2 p5 V, g8 c        if (!empty($prev_gid))
2 f  J& C& A, Q  n$ X        {
% u7 [4 T! D; M1 _/ y; n            $prev_good['url'] = build_uri('goods', array('gid' => $prev_gid), $goods['goods_name']);
8 j- q: {( \2 c7 `! w1 h6 r            $smarty->assign('prev_good', $prev_good);//上一个商品
0 V2 \0 l8 M& _. j+ \$ L, c        }

        $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");% `" V% d. g( H8 F; o3 v6 x
        if (!empty($next_gid)); S4 \( P8 a6 g; C
        {
: ]8 U  j- V1 P+ W            $next_good['url'] = build_uri('goods', array('gid' => $next_gid), $goods['goods_name']);
6 g9 B/ k) b  y4 x7 x            $smarty->assign('next_good', $next_good);//下一个商品
0 L$ F0 C; N1 z- h5 s9 D8 d        }

/* 上一个商品下一个商品 */
9 R, N, d1 W# m2 e' Q+ d7 \4 v$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");0 Q0 M9 k% g9 z* ]: T
        if (!empty($prev_gid))
5 d' v. |  i. e        {' e; v) I1 ^. R# v& Q5 Y
            $prev_good['url'] = build_uri('goods', array('gid' => $prev_gid['goods_id']), $goods['goods_name']);7 u5 G5 q+ r) M6 K# f4 z3 ~- c/ i
            $prev_good['goods_name'] =$prev_gid['goods_name'];
8 O6 q0 F! q8 O4 h" j5 @$ p: j) Y            $smarty->assign('prev_good', $prev_good);//上一个商品
' D1 k4 G0 ]0 b# s        }

        $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");
2 m$ \2 W  h' J2 `3 W$ z        if (!empty($next_gid))) X% S: N4 v1 t5 ~) u/ p
        {& O2 r0 O# M/ k
            $next_good['url'] = build_uri('goods', array('gid' => $next_gid['goods_id']), $goods['goods_name']);4 ?, _, D, l' w7 m$ V; Y; A1 {
            $next_good['goods_name'] =$next_gid['goods_name'];
8 s( n, d7 c8 J7 A# N0 A& t            $smarty->assign('next_good', $next_good);//下一个商品% S( |: n% a' V( M% N2 a! q1 Q
        }