loren646 Posted April 4, 2013 Share Posted April 4, 2013 got three columns Table: Rentals: Columns: house number, street, owner. what's the coding? "SELECT owner FROM Rentals" Not sure what to write so i don't select duplicate owners. or is it better to select all and then when echo don't echo the duplicates? Link to comment https://forums.phpfreaks.com/topic/276544-how-to-select-but-no-dupes-also-logical-question/ Share on other sites More sharing options...
Barand Posted April 4, 2013 Share Posted April 4, 2013 SELECT DISTINCT owner FROM rentals Link to comment https://forums.phpfreaks.com/topic/276544-how-to-select-but-no-dupes-also-logical-question/#findComment-1422963 Share on other sites More sharing options...
loren646 Posted April 4, 2013 Author Share Posted April 4, 2013 thanks Sen Link to comment https://forums.phpfreaks.com/topic/276544-how-to-select-but-no-dupes-also-logical-question/#findComment-1422971 Share on other sites More sharing options...
Barand Posted April 4, 2013 Share Posted April 4, 2013 You're welcome, Advanced Link to comment https://forums.phpfreaks.com/topic/276544-how-to-select-but-no-dupes-also-logical-question/#findComment-1422974 Share on other sites More sharing options...
Jessica Posted April 4, 2013 Share Posted April 4, 2013 I think we need to change the position of our usernames. Because amazingly numerous people can't figure out that everyone else's name is in the same spot as their own username. Link to comment https://forums.phpfreaks.com/topic/276544-how-to-select-but-no-dupes-also-logical-question/#findComment-1422976 Share on other sites More sharing options...
Barand Posted April 5, 2013 Share Posted April 5, 2013 I wholeheartedly agree with you, Dallas Link to comment https://forums.phpfreaks.com/topic/276544-how-to-select-but-no-dupes-also-logical-question/#findComment-1423165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.