help need while creating tree structure

Shell Programming and Scripting
1

Hi Experts,

I have table in mysql like below:

'user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` 

varchar(100) NOT NULL,
  `member_name` varchar(100) NOT NULL,
  

`city` varchar(100) NOT NULL,
  `member_id` varchar(100) NOT 

NULL,
  `password` varchar(100) NOT NULL,
  `position` varchar(100) 

NOT NULL,
  `join-date` datetime NOT NULL,
  PRIMARY KEY 

(`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 

AUTO_INCREMENT=7 ;

According to member ID, I want to show parent ID with name and tree view.

Thanks,
Deepak

2

Hi,

Please let me know if my query is not clear to you.

Thanks,
Deepak