Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Search returning multiple results based on database foreign key table

Search returning multiple results based on database foreign key table

Thread began 8/08/2017 4:18 pm by tmcbinc99963 | Last modified 8/15/2017 2:19 pm by tmcbinc99963 | 1164 views | 10 replies

8/15/2017 12:01 pmRay BorduinWebAssist

How do I view the page with the problem?

You may need to add a DISTINCT specification to the GROUP_CONCAT() function call to remove the repeats it is returning:
SELECT *, Group_Concat(DISTINCT Lube) AS LubeCats

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.