Displaying unique results only once

[keith73]

I have a database of orders. Each order can contain many products and they are stored on separate rows.

Example:
Order # | Part # | Description
12345 | 88865 | Widget
12345 | 9543 | Thingamajig

I want the results to return just a list of order #'s and not repeat them. I already have it so that clicking on the order # gives more detail on the order, but the MySQL results give me each order # as many times as it appears.

Thanks in advance,
- Keith

[crusty_php]

The answer is DISTINCT
see:
http://www.mysql.com/doc/S/e/Selecting_columns.html

[keith73]

ahhh, I had actually found DISTINCT on mysql.com but was using it incorrectly.

Thanks,
- Keith