RE: [PHP-DB] how to store a heirarchy of resellers and customers WAS: newbie help

Also, you really should use a more descriptive subject line, 'newbie help' is kind of weak. If everyone did that, nobody would be able to search subjects or distinguish one topic from another. I won't even get into the whole 'top/bottom post' B.S. (personally I think top posting is great as you don't have to scroll. So you read bottom up if you want to know the thread) Ooops. Sorry. I guess I did get into it a bit. ;-p Something like, "how to store a heirarchy of resellers and customers" > > -----Original Message----- > > From: nhadie [mailto:nhadie@tbgi.net.ph] > > Sent: Thursday, September 27, 2007 8:31 PM > > To: php-db@lists.php.net > > Subject: [PHP-DB] newbie help > > > > Hi All, > > > > I would like to setup a system something like this > > > > > > > > customer A > > > > > > / \ > > > > > > cust 1 cust 2 > > > > > > / \ \ > > > > > cust B cust C cust D > > > > customer A has customer 1 and 2, cust 1 has cust B and C etc, etc. > > what i'm after is when a customer user logs in he can only > > see record > > of its customer, e.g cust A logs in, it can only see records > > of cust 1 and cust 2, > > if cust 2 is login it can only see cust D and so on > > > > how would i approach this? should every customer have it's > > own database, > > consisting of all tables i need e.g customer detail table, > > and i will use the database name as session variable, so > > that when they > > add records it be inserted on table under that database? > > > > sorry if my questions are confusing, hope anyone can help > me, i just > > need help on how to approach it at the beginning so it will > > not be messy > > later on. Thank you. > > > > Regards, > > Nhadie > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >