Hash Variables for many users

 
1
0
-1

Hi,

I have a form ( Table Name : sr )
i used a multi select box > User Options Binder ( ID : members ) to select many users

in another form I want to design a table containing the data (Full name - Email - Jobtitle) of each user that was selected

What the Hash Variables can i write to show this information؟

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Use Loadbinder to load the data and use "FIND_IN_SET()" mysql function and display the data of all selected users.
      you might want to replace ';' with ',' using "REPLACE" mysql function.


      You might be able to use this query below. my field "t.c_dockTeam" contained the multiselected user column


      SELECT d.id, concat(d.firstName, ' ', ifnull(d.lastName, ''))
      FROM dir_user d
      LEFT JOIN app_fd_teamformate t ON find_in_set(d.id, REPLACE(t.c_dockTeam, ";", ",")) > 0

        CommentAdd your comment...