RE: [PHP-DB] Listing parent ids
| From: | Arno Kuhl | Date: | Thu, 28 Jul 2011 11:49:26 +0000 |
| Subject: | RE: [PHP-DB] Listing parent ids | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47938@lists.php.net to get a copy of this message | ||
> I'm currently using MySQL but I'll switch databases if there's a
> compelling reason and no drawbacks.
> Thanks for the lead, I'm googling recursive queries.
'common table expression' is the thing to google for, but MSDN seem to have
hijacked all the top spots.
http://syntaxhelp.com/SQLServer/Recursive_CTE
is a nice example of what you
outlined ...
--
Lester Caine - G8HFL
-----------------------------
Thanks Lester. The data structure is a good example of what I outlined.
I want to avoid the recursion, whether in php or sql, possibly by using the
nested set model.
Cheers
Arno