Contacts List

Hi, oddly how i first came to Kirupa to learn about Flash and i end up here in mySQL, but that aside…

I have a query to write which i struggle defining. Bear with me.

I have a contact list that for each contact there is two contact fields, contact1 and contact2. These 2 contacts are contained within the contacts table. Note here that yes this is straight forward, but i also want to bring back the contacts of those two contacts, therefore 6 contacts at this stage. I endeavour to expand this to include at least 2 more layers of contacts (sort of building up a contact history, who knows who sort of idea), but believe that cracking the first hurle will lead to the inclusion of the next layers.

I am looking for speed of response, so lengthy loops may not be the answer. I am posting here in the hope some’one understands my dilemma and can help me along the way.