[SOLVED] CreateInputDropdown make a DISTINCT?
Posted: Mon Nov 19, 2012 11:15 pm
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
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