Jump to content


problem in select query


1 reply to this topic

#1 purnendu

    Advanced Member

  • Members
  • PipPipPip
  • 64 posts

Posted 02 June 2009 - 09:48 AM

Hi,
I am new to mysql and if any body help me in query display that would be gra8 for me.

http://[img]http://[img][img][/img][/img][/img]I am ranjan a new bie to mysql.plz help me.
I am working on one project where i have one table as below:
Table name: register
Table field name:
sno Pk autoincrement
username
first_name
last_name
DOB
password
parent_name
position
amount
User can register into register table and select the parent name and after selecting the
parent name he has to choose where he will join at left side or right side(position). I have to display the record in tree format like below. How to do this plz.

#2 mohsin

    Newbie

  • Members
  • Pip
  • 0 posts

Posted 23 January 2010 - 09:06 PM

Like below??





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users