[SOLVED] CreateInputDropdown make a DISTINCT?

[nervino]

Hi All,
I've a recordset with which I create a dropdown list with CreateInputDropdown():

The query is something like:
SELECT * FROM etc.

I forgot to distinct the results (SELECT DISTINCT * FROM etc.)
and with $dbresult>RecordCount() I got 14 records, BUT in the dropdown I have only 9!
I changed the query adding the DISTINCT clause and it correctly returns 9 records.

Does CreateInputDropdown() function make a sort of "distinct"?

thank you

[Jos]

Yes, just take a narrow look at the array you were assigning to the CreateInputDropdown function

[nervino]

thanks Jos