helpmeplease2 Posted April 9, 2007 Share Posted April 9, 2007 How can I make it so if to results are the same that it only shows it once? For example if the field "game" is equal to "Mario" and there is another game also equal to "Mario" that it only shows mario once. Link to comment https://forums.phpfreaks.com/topic/46222-solved-dont-show-repeat-results/ Share on other sites More sharing options...
btherl Posted April 9, 2007 Share Posted April 9, 2007 You can use "GROUP BY game" at the end, or you can use "SELECT DISTINCT game" at the start. Which is more appropriate depends on your situation. If you are selecting other columns as well, you need to think of what to do with the multiple values you have for those rows. Again, how you deal with that depends on the situation. Link to comment https://forums.phpfreaks.com/topic/46222-solved-dont-show-repeat-results/#findComment-224723 Share on other sites More sharing options...
helpmeplease2 Posted April 9, 2007 Author Share Posted April 9, 2007 Thanks! DISTINCT did the trick. Link to comment https://forums.phpfreaks.com/topic/46222-solved-dont-show-repeat-results/#findComment-224777 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.