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 :/ Quote 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 Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/254073-duplicates-driving-me-insane/#findComment-1302558 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.