Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (3)

Resolved Duplicate select option in search

  1. jimbo
    jimbo
  2. Support
  3. Saturday, August 15 2015, 01:17 AM
Hi,

I've made a select field with I've made searchable. It targets a company_name column so users can search by company.

It works well but lists duplicate entries if more than one user works for the same company.

Is there a way to stop duplicate entries showing? Any help with the correct Sql WHERE parameter to use would be much appreciated.

Thank you.
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
try with
id>0 GROUP BY company_name
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (3)
jimbo
jimbo Accepted Answer
Basic
I thought this might work but still no good:

company_name IN (SELECT DISTINCT company_name FROM #__jsn_users)
  1. more than a month ago
  2. Support
  3. # 1
jimbo
jimbo Accepted Answer
Basic
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
no idea how - but it works!
SQL where write filter directly on DB query, "GROUP BY" MySql statement is used to group the result-set by one or more columns.
  1. more than a month ago
  2. Support
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.