[Resolved] Limiting # of values returned if same value returned more than once

[dougmcc1]

Here is my table:
col1 col2
book1 author1
book1 author2
book1 author3

What I want to do is populated a drop down menu with each entry in col1 listed only once.

If I do this:
select col1 from table

then book1 gets listed 3 times.

So my question is how do I limit the number of values returned to 1 if the same value is returned more than once?

Thanks.

[weekender]

there are two ways to do this

with SQL -

$sql = "SELECT DISTINCTROW(col1) FROM table....";

distinctrow returns unique values only.

or with arrays

read the col1 values into an array, then use the array_unique function

[dougmcc1]

Oh, that was easier than I thought. Thanks.