Re: A mysql select question.

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,711 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,407 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.

Join our community!

Please support our MySQL advertiser:

A mysql select question.

•

Join Date: Sep 2006

Location: Canada

Posts: 55

Reputation: GliderPilot is an unknown quantity at this point

Rep Power: 2

Solved Threads: 2

GliderPilot GliderPilot is offline

Offline

Junior Poster in Training

Re: A mysql select question.

Mar 5th, 2007

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.

-Chris

http://www.etyn.com