修改includes\lib_goods.php文件里的 function get_goods_gallery,具体如下:
$sql = 'SELECT img_id, img_url, thumb_url, img_desc' .
' FROM ' . $GLOBALS['ecs']->table('goods_gallery') .
" WHERE goods_id = '$goods_id' LIMIT " . $GLOBALS['_CFG']['goods_gallery_number']." ORDER BY img_id DESC ;
order by img_id DESC 是安降序排列,但它不能放在limit的后面.所以会报错,应该改成:
$sql = 'SELECT img_id, img_url, thumb_url, img_desc' .
' FROM ' . $GLOBALS['ecs']->table('goods_gallery') .
" WHERE goods_id = '$goods_id' ORDER BY img_id DESC LIMIT " . $GLOBALS['_CFG']['goods_gallery_number'];
更改完后是已上传的顺序为准,不会再跟后台的相册是一样的了,效果如下:
1,。前台展示:
后台顺序: