rockinaway Posted December 30, 2011 Share Posted December 30, 2011 I have a pretty substantial query in which there are a few joins and WHERE clauses. The important thing is that every row has a unique ID set for it, and IDs are not repeated in the database. However, in my where clause I have a section that says (first = id_one AND second = id_two) || (first = id_two AND second = id_one) I'm trying to get the different permutations of the information, but this is giving me duplicate rows. How can I prevent a row being repeated by using the unique id? I've tried SELECT DISTINCT at the start of my query but that doesn't seem to really do much :/ Link to comment https://forums.phpfreaks.com/topic/254073-duplicates-driving-me-insane/ Share on other sites More sharing options...
rockinaway Posted December 30, 2011 Author Share Posted December 30, 2011 Okay, I used GROUP BY for the id so it seems to be working, although if there are any better methods then please let me know Link to comment https://forums.phpfreaks.com/topic/254073-duplicates-driving-me-insane/#findComment-1302502 Share on other sites More sharing options...
ManiacDan Posted December 30, 2011 Share Posted December 30, 2011 Putting the word "DISTINCT" after "SELECT" will eliminate all duplicate rows. Link to comment https://forums.phpfreaks.com/topic/254073-duplicates-driving-me-insane/#findComment-1302544 Share on other sites More sharing options...
rockinaway Posted December 30, 2011 Author Share Posted December 30, 2011 Yeah, I forgot to add the GROUP BY, solved now Link to comment https://forums.phpfreaks.com/topic/254073-duplicates-driving-me-insane/#findComment-1302558 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.