Questions tagged [no-duplicates]
70 questions
0
votes
1 answer
How to write a single wordpress loop (not multiple loops) that prevents duplicate output
I am using a loop to display custom field values in a navigation area. Example: I have 100 posts on the page. Each post has a Brand associated with it (Fender, Gibson, etc.) maybe about 15 brands overall. The navigation loop will output the Brand…
WilliamAlexander
- 374
- 2
- 4
- 20
0
votes
1 answer
select distinct out of distinct
I have two table one has employees goals and the other has list of employees. i have to match one to another. Seems easy to do. but in the employee table employees can be entered more than once with more than one way of spelling their names. How can…
user2019324
- 25
- 1
- 8
0
votes
1 answer
Java ArrayList merge without duplicates based on a value
I have a class called Sample, this class has a property that is an ArrayList, and an Area contains an ArrayList
public class Sample {
private ArrayList sampleAreas;
public ArrayList getMergedData()
{
…
Andreo Vieira
- 360
- 2
- 8
0
votes
0 answers
Insert Into No Duplicate from another table only inserting
I've been fighting with this for hours now. I need to build a master table from multiple tables (bad design, I know.) I've written this code:
INSERT INTO amdashboard
(DashboardFirst, DashboardLast, charlotteorg, charlotteAdd1, charlotteCity,…
The Hammer
- 41
- 1
- 1
- 3
0
votes
1 answer
mysql join three tables not duplicate value
I have the following tables
--subscribers--
id
name
e-mail
--categories--
id
subscriber_id
cat1
cat2
... so on
--messages--
id
title
message
cat1
another field
...
My query needs to return title, message and subscriber mails. Every subscriber…
Delicja
- 193
- 1
- 8
- 18
-1
votes
2 answers
Duplicates counting with order order preserving in Python lists
suppose the list
[7,7,7,7,3,1,5,5,1,4]
I would like to remove duplicates and get them counted while preserving the order of the list. To preserve the order of the list removing duplicates i use the function
def unique(seq, idfun=None):
# order…
user3782691
- 11
- 1
-1
votes
4 answers
Removing duplicates (not by using set)
My data look like this:
let = ['a', 'b', 'a', 'c', 'a']
How do I remove the duplicates? I want my output to be something like this:
['b', 'c']
When I use the set function, I get:
set(['a', 'c', 'b'])
This is not what I want.
-1
votes
1 answer
Get records from database while leaving out duplicates
I have a table of zip codes in my MySQL database. It uses PHPMyAdmin and I'm using PHP code.
The table looks something like this:
zip_codes(id, zip, state)
The problem here is that I want to generate a quick list of the states in this table. …
SherwoodPro
- 105
- 10
-1
votes
1 answer
SQL: Join tables excluding duplicates in second table
I have two tables (Table1 and Table2) that need to be joined.
The column id links Table1 and Table2.
The output table needs to contain all rows in Table1.
Table2 has duplicates which should not show up in the output table.
If a duplicate row in…
slayernoah
- 4,382
- 11
- 42
- 73
-4
votes
1 answer
Load in multiple random .html files with PHP
I have 6 html files (test1.html, test2.html, test3.html and so on) and I want 3 of them to be randomly displayed with no duplicates. Then each time the web page is loaded a different order and file will be used.
Say: test1.html, test4.html,…
Martyn Gray
- 21
- 3