Hi there
0-------0
Sorry for stupid Q
but I have the following Table named People
OBJID -> int(11) not null auto_increment
NAME -> varchar(25)
PARENT_ID -> int(11)
Now if my data is as follows
OBJID | NAME | PARENT_ID
-----------------------------------------------
1 None 0
2 Other 1
how can I get the Childs back (those who's Parent_ID is not 0), But
Linked to a specific
Parent ID !!.
Like somehting like this
select * from People where PARENT_ID = OBJID and OBJID = 1
I know the obove wont work but I kinda neet something with that logic.
Thanks In advance for any help
Johannes
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php