Apr 15, 2020
0
Level 2
Problem with getting data from query
I have two tables
field_value id field_id value label sort
user_interests
user_id field_id value_id
I am trying to write a query where I will get user with id 1 and have field_id 2 and to be able to echo in my blade value_id 4 and 5 but not to echo those ids but to echo value of 'label' column that corresponds to value_id form user_interests table in this case 4,5 thus Chat, Friendship from field_values table in this example. Here is what I tried but I get array of six elements which are Relationship, Chat, Friendship x2. Any help is appreciated.
q
Please or to participate in this conversation.