Duplicate Search Results

I followed the tutorial to create a search/results page with Data Assist. It works well, except the results page shows duplicate entries. The recordset on the results page is created with a SELECT DISTINCT mysql statement, but still I get multiple results that are the same.

I have no idea how to fix this. Help would be sincerely appreciated.

What is the full recordset you are using?

what column has the duplicates you are trying to eliminate?

Hi Jason, thanks for your speedy reply.

The search page is at:

search.php

The results page is at:
results.php

and the code for each of the pages are attached.

In the search page online, if you choose only the "client safety" parameter, you'll see that there are several identical hits.

If this is more conducive to a paid ticket, I'm happy to do so as trying to meet a deadline.

I appreciate your help.
angelo

when you have a query that returns multiple columns, and you use distinct, the distinct keyword returns a distinct rowset.

instead of using distinct, you need to use a GROUP BY clause

it looks like the title column would be a good candidate.

at the end of the sql add:
GROUP BY tbl_Resource.resource_title

thanks Jason, you and your team always manage to quickly solve my issues. I'm very appreciative of your great products and fantastic customer service.
Angelo

you're welcome.