Jump to content


Photo

Duplicate Results


  • Please log in to reply
1 reply to this topic

#1 Jarin

Jarin
  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 27 June 2006 - 08:43 PM

I'm having a bit of a problem.. I have some PHP code that gets a result set from the database from an SQL array and performs a loop on them. However, some of the elements of the array may have duplicate values and MySQL weeds them out and only selects that particular row once. Say, for instance, we have this query:

SELECT * FROM items WHERE id IN ('1', '2', '3', '1')

('id' is the primary key in this case, each row is unique)

The query would only return the first '1' in the list. However, I need it to return both '1's so that I can perform the loop on both of them, even though it is the same data twice. I have yet to find a way to do this or a workaround for it. Any tips would be much appreciated.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 July 2006 - 02:09 AM

That's going to be a problem... MySQL will never return duplicate rows for a single-table query.  But since you can "know" that it's duplicate, why can't you simply process the extra interations in PHP directly?  No need for the DB to do more work!
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users