Page 1 of 1

[SOLVED] CreateInputDropdown make a DISTINCT?

Posted: Mon Nov 19, 2012 11:15 pm
by 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

Re: CreateInputDropdown make a DISTINCT?

Posted: Mon Nov 19, 2012 11:28 pm
by Jos
Yes, just take a narrow look at the array you were assigning to the CreateInputDropdown function

Re: CreateInputDropdown make a DISTINCT?

Posted: Tue Nov 20, 2012 9:17 am
by nervino
thanks Jos