如何使用可点击链接id分组group_concat

Question

Output:

//HotelID   //HotelName   //Operators 1,2,3

1    -       Nila    -    CleanX,Vey,Leo  

I want the operators to be individual clickable links , asigned to their IDs.

With GROUP_CONCAT they're all combine into one ID. I used LEFT JOIN in MYSQL

I Want it this way "this is just an example.Code wise it wont work"

Every id will be a link to click

//HotelID //HotelName //Operators 1,2,3
1    -     Nila   -  CleanX id1, Vey id2, Leo id3

Instead of all GROUP_CONCAT to one ID.

Is there a way since operators are GROUP_CONCAT in Mysql query to prevent duplication when echoed out.

Is there a way maybe to just GROUP but not GROUP_CONCAT Help please.

Answer 1

Just use this query. The rest of your problem is about data display and user interface, all of which is best handled in application-level code (e.g. PHP).

SELECT h.hotelID
     , h.hotelName 
     , o.opID
     , o.opName
  FROM hotels h
  LEFT 
  JOIN operators o
    ON o.opHotelID = h.hotelID 
 ORDER 
    BY h.hotelID
     , o.opID;