Jump to content

Archived

This topic is now archived and is closed to further replies.

DaveLinger

I bet you guys just LOVE all of my SQL questions!

Recommended Posts

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?

Share this post


Link to post
Share on other sites
SELECT DISTINCT column_name FROM table ... enjoy :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.