[plug] PHP / mySQL - recursive query problem

Ady Gould KiltOtter at bdu.org
Tue Mar 30 07:23:26 WST 2004


> Your table structure is precisely right :)
> 
> Ady: What precisely is the nature of this project if its not 
> a rude or business secret trashing sorta question?

It's actually part of a project for my students - I came up with the idea of
the self referencing table to store resources and categories. More precisely
the categories that the resources belong to:

Business -> Finance -> Accounting
Business -> Finance -> Banking
Computing -> Software -> Microsoft -> Office
Computing -> Software -> Microsoft -> Office -> Powerpoint
Computing -> Software -> Microsoft -> Office -> Word
Computing -> Hardware -> Motherboards
Etc






More information about the plug mailing list