NargsBrood

are you getting an error or just no results? is your ID field a numerical or a string? if it is string then: try '%S' vs '%s' Use: SELECT payment FROM invester WHERE ID LIKE '%' if nothing is returned then your table is empty.

http://forums.devshed.com/mysql-help-4/returning-multiple-levels-from-same-table-592263.html#post2211788 resolved

are you sure this reply was for this thread? i dont understand how it applies in the least

You can find word lists everywhere if you do a google search.... you will have to import the list into your db structure though which shouldnt be hard. try this site http://www.net-comber.com/wordurls.html

cousins: I dont think MySQL is power enough to do this one but give it a try: select * from [table] where mother_id = ( select id from [same table] where mother_id = (select mother_id from [table] where id = ( select mother_id from [table] where id = [id for person you want cousins of] ))) grandmother: select * from [table] where id = ( select mother_id from [table] where id = ( select mother_id from [table] where id = [id for person you want grandparents of])) newphes: and i dont think MySQL is power enough to do this one either: select * from [table] where mother_id = ( select id from [table] where mother_id = ( select mother_id from [table] where id = select mother_id from [table] where id = [id for person you'd like newphews of]))

I have a groups table that sort of has this structure: group_id PK parent_group_id FK points to group_id of same group table group_name ect... The parent_group_id gives ownership of a group to another group and this can continue down several levels. Now - Group_D has parent id pointing to Group_C who has a parent id pointing to Group_B who has parent id pointing to Group_A If an object belongs to Group_D then it also belongs to Group_C and so belongs to B and so belongs to group A. What would be the most efficient way to return all of the groups that an object belongs to? So - an Object belongs to Group D and so i want to return D, C, B, and A. i've tried select * from groups where group_id = [Group_D's group_id] or group_id = ( select parent_id from groups where group_id = [Group_D's group_id] ) or group_id = ( select parent_id from groups where group_id = ( select parent_id from groups where group_id = [Group_D's group_id] ) ) or group_id = ( select parent_id from groups where group_id = ( select parent_id from groups where group_id = ( select parent_id from groups where group_id = [Group_D's group_id] ) ) ) I can keep adding nested selects for each level I want to go up the chain but MySQL has an issue with this when i get to the 4th or 5th level... it errors out. Is there a better, more efficient way to do this that doesnt use all of the nested selects that wouldnt be too much for MySQL to handle?