DISTINCT 作用于整行
你的3个表中只要存在一对多的情况就难说了
你的3个表中只要存在一对多的情况就难说了
解决方案 »
- PHP 根据前台传递的字符计算值
- 用php或asp怎么制作像百度空间和163博客那样的系统啊?
- 使用jquery ajax中文乱码问题
- 求助,php生成带图片的word问题
- 什么道理。php的中文搜索问题
- (急)Can't connect to MySQL server on 'localhost' (10061)
- PHP怎样生成静态页。 我用的是class.FastTemplate.php3
- php.exe应用程序错误["0×100b4d56"指令引用的"0×00000000"内存,该内存不能为"read"]这样的报错是怎么回事?
- 一个关于PHP的新问题
- /brand/?do=xxx 可以访问 /brand?do=xxx 不能访问,怎么控制?
- 提示它的原因是什么
- eclipse上运行PHP, 选择web page,编译然后跳到浏览器执行了,
select DISTINCT * from
(`object_id`, t3.width as width, t3.height as height,t3.is as is, t2.rtime as add_time,t1.add_author as add_author,t1.image_url as image_url,t1.id as id,t1.browse_real_cnt as browse_real_cnt
from comments as t2
left join ornamentations as t1 on t1.id = t2.object_id
left join ornamentation_images as t3 on t3.ornamentation_id = t1.id
where ( t2.uid = 1013 ) AND ( t1.enable = '0' )
ORDER BY t2.id desc) T
LIMIT 0,5
from comments as t2
from错了
..... from
(select `object_id`, t3.width as....