You can also use the DISTINCT function to get distinct records and also make your query dynamic (using conditions in the FROM section) in terms of what is inputted from the search form.
========================================
Buh Bye!
Cheers,
Me
========================================
Buh Bye!
Cheers,
Me