$sql = "select g.goods_id,g.goods_thumb,g.goods_name,g.goods_number,g.promote_price,g.shop_price,g.et_price,wg.wish_goods_id,wg.goods_number from ". $GLOBALS['ecs']->table('wish_goods') . ' as wg left join '. $GLOBALS['ecs']->table('goods') .' as g ON wg.goods_id = g.goods_id where wg.user_id = '. $_SESSION['user_id'] .' AND wg.is_save = 0 ' ;
return $GLOBALS['db']->getAll($sql);g.goods_number与wg.goods_number 字段名重复了。 取出的数组,不对。取出的数据是下面的Array ( [0] => Array ( [goods_id] => 7331 [goods_thumb] => images/201105/thumb_img/7331_thumb_G_1304557615776.jpg [goods_name] => 春季T恤衫 [goods_number] => 999 [promote_price] => 0.00 [shop_price] => 151.00 [et_price] => 181.20 [wish_goods_id] => 133 ) [1] => Array ( [goods_id] => 164 [goods_thumb] => images/201104/thumb_img/164_thumb_G_1302498508741.jpg [goods_name] => 帅气大表盘腕表 [goods_number] => 999 [promote_price] => 0.00 [shop_price] => 325.00 [et_price] => 390.00 [wish_goods_id] => 132 ) [2] => Array ( [goods_id] => 7347 [goods_thumb] => images/201105/thumb_img/7347_thumb_G_1304558664614.jpg [goods_name] => 甜蜜丝带衬衫 [goods_number] => 999 [promote_price] => 0.00 [shop_price] => 293.00 [et_price] => 351.60 [wish_goods_id] => 131 ) )
求解,谁能给个办法 。分别取到 g.goods_number 和 wg.goods_number
return $GLOBALS['db']->getAll($sql);g.goods_number与wg.goods_number 字段名重复了。 取出的数组,不对。取出的数据是下面的Array ( [0] => Array ( [goods_id] => 7331 [goods_thumb] => images/201105/thumb_img/7331_thumb_G_1304557615776.jpg [goods_name] => 春季T恤衫 [goods_number] => 999 [promote_price] => 0.00 [shop_price] => 151.00 [et_price] => 181.20 [wish_goods_id] => 133 ) [1] => Array ( [goods_id] => 164 [goods_thumb] => images/201104/thumb_img/164_thumb_G_1302498508741.jpg [goods_name] => 帅气大表盘腕表 [goods_number] => 999 [promote_price] => 0.00 [shop_price] => 325.00 [et_price] => 390.00 [wish_goods_id] => 132 ) [2] => Array ( [goods_id] => 7347 [goods_thumb] => images/201105/thumb_img/7347_thumb_G_1304558664614.jpg [goods_name] => 甜蜜丝带衬衫 [goods_number] => 999 [promote_price] => 0.00 [shop_price] => 293.00 [et_price] => 351.60 [wish_goods_id] => 131 ) )
求解,谁能给个办法 。分别取到 g.goods_number 和 wg.goods_number
解决方案 »
- php+mysql 绘图
- 哪位大哥有清华大学出版社出的《PHP+MYSQL完全学习手册》这本书的光盘啊??
- jpgraph的问题: 很奇怪,同样的程序在windows上可以显示中文,在linux上就不行了,怎么回事?
- 中文分词和关键字应用请教(请勿简单回复,谢谢)
- 讨论一下像pear:db和adodb这些数据库抽象层(发言有分)
- 如何让parse_str不替换掉原有变量
- [ SQL ] 关于Left Join 的用法
- 用户要求按周按月结算一次,应该怎么来计算判断呢?谢谢
- 如何发送带附件的邮件?
- 求一个简易的mysql管理程序
- 急!!高分求教!!怎么可以通过遍历数据库实现一行多张图片列表而且实现分页功能
- 网站被黑了,,如何是好????
g.goods_number as gnum, wg.goods_number as wgnum