loren646 Posted April 4, 2013 Share Posted April 4, 2013 (edited) 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? Edited April 4, 2013 by loren646 Quote 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...
Solution Barand Posted April 4, 2013 Solution Share Posted April 4, 2013 SELECT DISTINCT owner FROM rentals Quote 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 Quote 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 Quote 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 (edited) 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. Edited April 4, 2013 by Jessica Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.