RE: how to store a heirarchy of resellers and customers WAS: newbie help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx] 
> > Sent: Thursday, September 27, 2007 8:31 PM
> > To: php-db@xxxxxxxxxxxxx
> > Subject:  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
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux