Posted by R. Rajesh Jeba Anbiah on 02/04/07 05:47

On Feb 2, 5:58 am, "Phil Latio" <phil.la...@f-in-stupid.co.uk> wrote:
> Let's say I have a simple web application running with just two MySQL
> tables. The tables structure is as follows:
<snip>
> As you can see Batley, Leeds and Bradford are sub-categories of West
> Yorkshire which itself is a sub-category of England.
>
> What I want to display when I am browsing through sub-categories of links is
> not only the name of that sub-category but it's category's parents, grand
> parents and so on like the below example.
>
> UK >> West Yorkshire >> Batley
<snip>

Answer is Nested Set Model architecture <http://dev.mysql.com/
tech-resources/articles/hierarchical-data.html>

--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/

• Next in forum: Re: Looking for PHP security tips
• Prev in forum: Re: I have sub-categories but want to display full category path
• Thread view: Re: I have sub-categories but want to display full category path

[Reply to this message]