Many databases can handle hierarchical SQL statements. For examples
oracle uses "START WITH / connect by".
eg. SELECT level L1, level_id, name
FROM company_level
START WITH level_id=21
CONNECT BY p
>Subject: Re: [PHP] Recursive Childs
> thanks for that, could you just explain how it should start, should i just
call the function, how does the level get determined ???
After the function ends, starting at
*
$conn = pg_connect("dbname=mydb us
>Subject: [PHP] Recursive Childs
> like hotscripts.com too, so i thought if someone could tell me how to use
get all the children :
>
> ID | NAME | PARENT
> 1X 0
> 2Y 1
> 3Z 2
> 4A 2
> 5F 1
> 6G 5
> if i want to get all children of 1, i want
Hi,
thanks for that, could you just explain how it should start, should i just call the
function, how does the level get determined ???
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the
4 matches
Mail list logo