Hi, can someone suggest the best way to perform a query that extract from a category table all the structure, like a filesystem? For example, I've a table of categorie like this: ID name descr ID_parent and I've assigned -1 to the root category. I'd like to draw a directory-like structure (like windows explorer), but I don't know how to extract a directory name, and all sub-directory recursively. Thaks. Carlo
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php