problem displaying certain results from a database

martincrumlish

Hi,

I am displaying some data from a mySQL database. A user uses a day, month and year dropdown to select a date and once they click submit the script displays entries for that date from a "name" column

If I select Dec 12, 2002 and in my table there are 6 rows like this

name | Date

I do a SELECT where the date is equal to what is in the Date column and then in a while loop I display the corresponding name. What i need to do is this: I only want to display any name once, even if it is in the column more than once for a given date. If I were to search for 2002-12-01 I would get this:

John
John
Mike
Mike
Sarah

I need this to display as:

John
Mike
Sarah.

Can someone help me with this?

Thanks,
Martin

tijger

hi martincrumlish,

from the mysql manual:
"The options DISTINCT, DISTINCTROW and ALL specify whether duplicate rows should be returned. The default is (ALL), all matching rows are returned. DISTINCT and DISTINCTROW are synonyms and specify that duplicate rows in the result set should be removed."

greetings, tijger

tserbis

try
SELECT DISTINCT ...

martincrumlish

Thanks for the replies.

I am not sure if this would work.....the result isnt actually a duplicate row. I should have went into more detail but along with the columns mentioned above there are about 10 or so other columns that all have different data.

it is only one field of each row that would be a duplicate....