Re: Thinking out loud - a continuation...

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


[snip]
> At one point you indicated all the data was coming from one table. Can you send me the table fields and indicate which fields are used to determine parent child relationship? Also 2 sample rows of data which have a relationship would be helpful.
[/snip]

Columns - tier1, tier2, tier3, tier4 etc. (ends with tier14)

Children of tier1 are tier2 -

select distinct tier2 from table where tier1 = "foo" and company = "1"
select distinct tier2 from table where tier1 = "bar" and company = "1"
etc.

Children of tier2 are tier3, etc.

	tier1		tier2		tier3
1, 	executive, 	ceo, 		ceo
1, 	executive, 	vp-ops, 		vp-ops
1, 	executive, 	vp-admin, 	vp-admin mgr
1, 	executive, 	vp-admin, 	vp-admin ops mgr
1, 	executive, 	vp-admin, 	vp-admin mgr
1, 	executive, 	vp-admin,	vp-admin clerk
1,	professional	pro-mgr		pro-admin
1,	professional	pro-IT		pro-dev
1,	professional	pro-IT		pro-infra
1,	professional	pro-IT		pro-dev
1, 	technician	tech-admin	tech-admin mgr
1,	technician	tech-ops		tech-ops mgr

Thanks for all of your help. I know I am being a PITA.
-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [Find Someone]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux