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? Quote Link to comment Share on other sites More sharing options...
AndyB Posted July 15, 2006 Share Posted July 15, 2006 SELECT DISTINCT column_name FROM table ... enjoy :) Quote Link to comment 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.