How to get single row data into a row with multiple columns

by Wajid Khan   Last Updated February 11, 2019 08:06 AM

I have a table as follows: Id Movie_name Person_Name Role_Name 1 mov1 xyz Singer 1 mov1 pqr Dancer 1 mov1 abc Actor 2 mov2 asd Director 2 mov2 fgh Producer

I need result like following Id Movie_name Person_Name Person_Name Person_Name Role_Name Role_Name Role_Name 1 mov1 xyz pqr abc Singer Dancer Actor 2 mov2 asd fgh Director Producer

Can anyone please help me out on this?

Tags : mysql-5.5 php


Related Questions


Updated November 15, 2016 08:02 AM

Updated April 09, 2015 22:02 PM

Updated August 24, 2018 15:06 PM

Updated December 27, 2018 07:06 AM

Updated June 11, 2015 18:02 PM