Duplicate MD5's

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
ghurtado
Forum Contributor
Posts: 334
Joined: Wed Jul 23, 2008 12:19 pm

Re: Duplicate MD5's

Post by ghurtado »

So "guid" and item_id were two different columns all along???
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Re: Duplicate MD5's

Post by GeXus »

Yeah of course... guid is varchar, item is int
User avatar
ghurtado
Forum Contributor
Posts: 334
Joined: Wed Jul 23, 2008 12:19 pm

Re: Duplicate MD5's

Post by ghurtado »

I think we were under the impression that your original query was pulling GUIDs, but I guess not.

Please try this and post the results:
SELECT count( * ) AS myCount, guid, item_id
FROM clicks
GROUP BY guid
HAVING myCount >1
ORDER BY myCount desc
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Re: Duplicate MD5's

Post by GeXus »

Hmm... This isn't good
#3 - Error writing file '/tmp/MY0vuQXT' (Errcode: 28)
Post Reply