NYCPHP Meetup

[LK]

Neil,

I happen to be struggling now with a database issue that might interest you and
I'd welcome and appreciate suggestions from the group.

My issue is: With a relational database how do you represent and navigate a
tree with unlimited number of levels and branches ? Example: categorization
hierarchy. Let's say you have a table of Employees. Now you want to categorize
them by Job_Type: clerk, secretary, manager, etc. But each one of these can be
further sub-categorized, e.g. Manager: production, purchasing, accounting etc.
Each one of those can also be sub-categorized in an unlimited recursive
fashion. 

One could try constructing a table with columns: level_0 level_1 level_2 etc.
where level_0 holds the 0-th level categories, level_1 - first level
subcategories, etc. But what if the number of category levels is potentially
unlimited - what do you do then?

Seems like this must have been dealt with before somewhere, and any suggestions
and pointers would be greatly appreciated.

Leo Kokin



--- Neil Argent <neil.argent at gmail.com> wrote:

> Following an absence from work due a long term illness, I have just 
> completed the CIW Master Designer qualification to assist me in my to 
> return to work.  
>  
> To facilitate my return, it is apparent that I need to learn PHP and 
> demonstrate its use with and without MySQL.
>  
> Could you suggest examples that I should write and use as part of my 
> portfolio.
>  
> I am not looking for detailed descriptions, just brief outlines of 
> projects that will demonstrate the skills being considered for PHP
> employment at this time.  
>  
> I have some experience of using PHP5 and PHP4 with MySQL, and a lot more 
> experience in C++, so I am not coming at it as a complete programming 
> novice.
> 
> Thanks.
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com