Hi, i want to make navigation links like the one given below Top->Category1->SubCategory1->SubCategory1 ---- --------- ------------ ------------ This lies at the top of every page and indicates which category or subcategory the user is in. These are links. One way of doing it is to drill down by parentid and category id recursively. But this is not a very optimized method. It issues one query per category per user. Any alternatives for this in php? Any pointers will be really helpful. thanx for your coperation. subhro PS: This is not like the directory structure of yahoo.com. There u always have the directory information. _____________________________________________________ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- PHP General 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]