限制查询数据库数据个数

最新推荐文章于 2024-08-21 09:09:31 发布

chuyinlu4874

最新推荐文章于 2024-08-21 09:09:31 发布

阅读量376

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/u/3224779/blog/851683

版权

function get_index_best( $limit = '')
{

$time = gmtime();

//取出所有符合条件的商品数据，并将结果存入对应的推荐类型数组中
$sql = 'SELECT g.goods_id, g.goods_name,g.click_count, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ' .
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.exclusive,".
"promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, RAND() AS rnd " .
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
"LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".
"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ";

$sql .= ' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.is_virtual=0 AND g.is_best = "1" ';
$sql .= ' ORDER BY g.sort_order, g.last_update DESC';
$sql .= " $limit";

$result = $GLOBALS['db']->getAll($sql);

（给$limit一个数字，倒序 order by desc ）

转载于:https://my.oschina.net/u/3224779/blog/851683