hello, does mysql allow for recursive SELECTS? is there a way to select a 'path in a tree' in one query ? (the tree is stored in the following form: parent_id int id int ) i know the ID of an element in n-th level of the tree, and i need to get all its parent elements --------------------------------------------------------------------- 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