# Contacts List

**URL:** <https://forum.kirupa.com/t/contacts-list/272375>\
**Category:** programming\
**Created:** [October 4, 2008, 7:23pm UTC](https://forum.kirupa.com/t/contacts-list/272375 "2008-10-04T19:23:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![MrInnoculator](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@MrInnoculator](https://forum.kirupa.com/u/MrInnoculator)\
**Post date:** [October 4, 2008, 7:23pm UTC](https://forum.kirupa.com/t/contacts-list/272375/1 "2008-10-04T19:23:10Z")

</div>

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.