Adding dropdown list box for searching dates

This topic is locked

Adding dropdown list box for searching dates		10/13/2010 23:05:57
PHPRunner General questions
R ryanhughes author Hi all, I was able to get the drop down list box with values for searching dates to work via this: http://xlinesoft.com/phprunner/docs/add_dropdown_list_box_with_values_for_search.htm I changed 'company' to 'date' My problem is that the drop down list shows duplicate entries instead of just 10/13/10 for all 10/13/10 entries, 10/12/10 for all 10/12/10, etc.. How can I get it to not show duplicate dates in the drop down list? Thanks, Ryan


	Sergey Kornilov admin 10/14/2010
	Try > select DISTINCT date from ...