Hi Bruno

It looks like you're trying to do a hierarchical query. What database are 
you using? If you're using Oracle you're in luck, see the docs for the 
START WITH and CONNECT BY clauses of SELECT. I don't think many other 
databases can do this so you would need to write code in your client 
language to interpret the catParentId to catId relationship.

Simon

On Wednesday 20 October 2004 03:47, Bruno B B Magalhães wrote:
> Hi guys,
>
> I have a normal categories table:
>
> catId
> catParentId
> catName
> catStatus
>
> But I want when a user enters on:
>
> http://hostname/site/products/catId1/catId7/catId13/../../contentId.html
>
> A listing should apear like that:
>
> • Category 1
>       • Category 7
>            • Category 13
> • Category 2
> • Category 3
> • Category 4
> • Category 5
>
>
> A reverse (or backward) loop! We need to get the last category and then
> follow the ParentId until the 0 ParentId. Have anybody made this before
> (I hope so)?
>
> Many Thanks,
> Bruno B B Magalhaes

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Simon Rees  |  [EMAIL PROTECTED]  |
ORA-03113: end-of-file on communication channel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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

Reply via email to