•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 374,023 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,766 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1475 | Replies: 4
 |
•
•
Join Date: Oct 2006
Posts: 7
Reputation: 
Rep Power: 0
Solved Threads: 1
Newbie Poster
I have a db full of articles that have a category field.
Is there anyway to select and display just the different categories?
Is there anyway to select and display just the different categories?
•
•
Join Date: Sep 2006
Posts: 91
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster
Sure...
select distinct category from articles;
select distinct category from articles;
The Blog Experiment Forum - Join the Conversation!
brainyminds | ilovecode
Ultimate Merchant Account Resource
brainyminds | ilovecode
Ultimate Merchant Account Resource
•
•
Join Date: Oct 2006
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
No, that's easy. What I am trying to do is make a list of the categories in the database without already knowing what is in it so oI can make a menu with links.
•
•
Join Date: Sep 2006
Location: Canada
Posts: 55
Reputation:
Rep Power: 2
Solved Threads: 2
Junior Poster in Training
asuming your field is named catagory your SELECT command would look something like this:
SELECT DISTINCT catagory FROM article_db ORDER BY catagory;
This would go through the catagory field, select all the Unique entries so each catagory name only appears once, and displays them in alphabitical order.
SELECT DISTINCT catagory FROM article_db ORDER BY catagory;
This would go through the catagory field, select all the Unique entries so each catagory name only appears once, and displays them in alphabitical order.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- MySQL++ query question (C++)
- MySQL SELECT rows In a Date Range (MySQL)
- Question about SELECT statement (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: how to create mailing list
- Next Thread: SQL Server 2005 version Error Insert command help me
