如何摆脱这些重复的行? [英] How do I get rid of these duplicate rows?
本文介绍了如何摆脱这些重复的行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有没有人对我如何从结果数组中获取这些重复行有任何建议?
如果你看这里:
Clickbank超级分析仪
然后只需点击Analyze Clickbank Now按钮
你会看到这些都有双重条目:
ID:AFFSUPER
ID:COHYPNOSIS
ID:MAVERICK66
我想展示其中一个(第一个)
这是输出该列表的脚本:
(如果大约十个,这只是一个)
Does anyone have any advice about how I
can get these duplicates rows out of my results array ?
If you look here:
Clickbank Super Analyzer
Then just hit the Analyse Clickbank Now button
you will see these all have double entries:
ID: AFFSUPER
ID: COHYPNOSIS
ID: MAVERICK66
I want to just show one of them (the first one)
This is the script that outputs that list:
(this is just one if out of about ten)
展开 | 选择 | Wrap | 行号
推荐答案
一些可能性:
1)不要循环结果集。
2)限制你的SQL查询(SELECT? LIMIT 1)
some possibilities:
1) don?t loop over the result set.
2) limit your sql query (SELECT ? LIMIT 1)
谢谢,
我相信你的意思很好,但是你确实是这样吗?b $ b看看脚本产生的列表?
(只需点击两下)
我需要遍历结果以便我可以
得到所有结果,我只是不想得到
重复的结果。
请通过<看看输出br />
链接,它显示我的意思。
谢谢
Thanks,
I am sure you meant well, but did you
take a look at the list that script produces ?
(it is only two clicks away)
I need to loop through the result so that I can
get all of the results, I just do not want to get
the duplicate ones.
Please take a look at the output via the
link, it shows exactly what I mean.
thanks
复制品有不同的类别是怎么回事然后?您可以尝试选择DISTINCT *(SELECT DISTINCTROW)但我不确定,它是否适合你。
* - 约为页面的五分之一
how does it come that the duplicates have different categories then? you may try SELECT DISTINCT* (SELECT DISTINCTROW) but I’m not really sure, whether it works for you.
* - at about one fifth of the page
这篇关于如何摆脱这些重复的行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文