Ok, what actualy do you wanna do? Sort records by dependencies, then other records(that don't have them) sort in other order(alphabeticaly or in order of appearance in the table)? if it is so you can do this: SELECT fieldName FROM table ORDER BY dependatOn,fieldName(or id - an auto_increment field)
<sql,query> -- Best regards, Evgeny mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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
