I'm trying to solve a problem... I have a site divided in areas. Each
area has it's own id, and may have it's own sub-areas. Each sub-area has
it's own sub-areas, etc...
My will is to return the areas in some cascade order... I can do it
recursively, but it generates too many queries. I was wondering how i could
do this with only one query to the database.
Here's the structure i have so far:
AREAS (area_id INT; parent_id INT; root_id(??) INT; description
VARCHAR(60));
Can anyone help?? Thanks in advance...
PS: I think this would very similar to a threaded forum...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
