Im trying to Select from multiple rows in my MySql database and return the results but exclude repeats, then place these results as option values in a select dropdown menu in a forum.
Does anyone have an Idea how I can write the select statement?
How to select from multiple rows, and exclude repeats?
Moderator: General Moderators
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
look here for some drop down ideas:
viewtopic.php?t=22329
and try this for a query
viewtopic.php?t=22329
and try this for a query
Code: Select all
SELECT DISTINCT column1, column2
FROM tablename
WHERE column1 = 'criteria'