怎样把下面的mysql转化成sql server
$sql = "SELECT g.goods_id, g.goods_name, g.et_price, g.shop_price AS org_price, ".
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
"g.promote_price, g.promote_start, g.promote_end, g.goods_thumb, g.goods_img, g.goods_brief ".
"FROM " .$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]' ".
"WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in".
" AND (( 1 " . $categories . $keywords . $brand . $min_price . $max_price . $intro ." ) ".$tag_where." )" .
" ORDER BY $sort $order";
$res = $db->SelectLimit($sql, $size, ($page - 1) * $size);
$sql = "SELECT g.goods_id, g.goods_name, g.et_price, g.shop_price AS org_price, ".
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
"g.promote_price, g.promote_start, g.promote_end, g.goods_thumb, g.goods_img, g.goods_brief ".
"FROM " .$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]' ".
"WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in".
" AND (( 1 " . $categories . $keywords . $brand . $min_price . $max_price . $intro ." ) ".$tag_where." )" .
" ORDER BY $sort $order";
$res = $db->SelectLimit($sql, $size, ($page - 1) * $size);
解决方案 »
- 【未定义变量】Notice: Undefined variable
- Fatal error: Allowed memory size of 8388608 bytes exhausted
- 能不用循环和分开的数组一次性获得所有a标记的值吗?,如前;怎么用正则只获取一段代码里面<a></a>里面的值?包含<a>标记
- 问一个伪静态的问题
- php如何执行一个字符串形式的函数并获得函数的执行结果,在线等,急!!
- php如何查看一个对象的类型?gettype永远是object!
- PHP中 如何实现这个正则 替换?
- 紧急求助!!php网站被攻击。
- 我还有119分,我给你100分,你给我回答我的问题吧?谢谢了!
- 这段话说明了什么?
- 诚聘网站PHP工程师,主要为网站B/S系统程序开发
- 有一个想法:用PHP程序做监控,要通过串口通讯,以前没有做过这块--大家来讨论一下
哦 ,是一样的呀