DaveLinger Posted July 15, 2006 Share Posted July 15, 2006 Here's another. I have game reviews listed in the table nuke_seccont (we're converting from PHP nuke to a hand coded layout, so we're using the reviews from where they are as opposed to moving 900+ reviews, for now.), and each row has the title, id, developer, publisher, etc. etc. On the review SEARCH page I'm working on, there is a drop down box with the developers and one with the publishers, to narrow your search. The problem is that there are dozens and dozens of developers/publishers and it would be a PITA to update the page every time a new developer or publisher were added. SO, I was thinking...is there a way to get all the "developer" or "publisher" column (seperate queries, btw) results, sift out the duplicates, and then echo until there are none left? Link to comment https://forums.phpfreaks.com/topic/14721-i-bet-you-guys-just-love-all-of-my-sql-questions/ Share on other sites More sharing options...
AndyB Posted July 15, 2006 Share Posted July 15, 2006 SELECT DISTINCT column_name FROM table ... enjoy :) Link to comment https://forums.phpfreaks.com/topic/14721-i-bet-you-guys-just-love-all-of-my-sql-questions/#findComment-58718 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.