I have a table in which I want to retrieve the table as follow.
Login Name Parent User Email ID Mobile No
abc abc_parent abc@abc.com 9999999999
MySql Table as follow in tbl_users
user_id parent_user loginname email mobile
321 123 abc_parent abc@abc.com 9999999999
231 456 abc 123@123.com 8888888888
I am having issue as mentioned on the top, I am not able to retrieve the data for parent user as abc_parent, am able to achieve to get parent user id not the parent user loginname as all loginnames come in single column and ids come in first 2 columns.
How can I show the parent user loginname in place of parent_user id.
Currently, i use the following code.
SELECT * FROM tbl_users where status_id='2'
any help will be appreciated, thanks