cheechm Posted August 7, 2008 Share Posted August 7, 2008 Hi, I have got these results: +-----------+ | Catalogue | +-----------+ | Cat1 | | Cat1 | | Cat2 | | Cat3 | +-----------+ So I query saying SELECT * from Catalogue. The results returned are: Cat1 Cat1 Cat2 Cat3 But you see there is two Cat1s. How do I make it so that if there is a result which is the same, only one of them is displayed? So I get this: Cat1 Cat2 Cat3 Thanks Link to comment https://forums.phpfreaks.com/topic/118678-solved-mysql-results/ Share on other sites More sharing options...
wildteen88 Posted August 7, 2008 Share Posted August 7, 2008 Use SELECT DISTINCT instead. Link to comment https://forums.phpfreaks.com/topic/118678-solved-mysql-results/#findComment-611035 Share on other sites More sharing options...
cheechm Posted August 7, 2008 Author Share Posted August 7, 2008 Thanks! Solved! Link to comment https://forums.phpfreaks.com/topic/118678-solved-mysql-results/#findComment-611039 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.