Hello fellow php scripters, I am new to this forum, so please be easy on me. I don't have much experience, but i like to tell myself i do. ;) I made a database driven navigation menu, or a folder structure menu... whatever you would like to call it. it's structure is quit easy. CREATE TABLE `file_manager` ( `id` int(11) NOT NULL auto_increment, `menu_id` int(11) NOT NULL, `menu_name` varchar(128) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=138 ; So let's say i have 5 menu items and all items have several sub items.. I want to delete a item with sub items, here i get stuck with my loop. $result = mysql_query("SELECT * FROM article_menu WHERE id='$is_the_first_item_to_delete'"); while($row = mysql_fetch_array($result)){ $result_sub = mysql_query("SELECT * FROM article_menu WHERE id='$row[menu_id]'"); while($row_sub = mysql_fetch_array($result_sub)){ mysql_query("DELETE FROM article_menu WHERE menu_id='$row_sub[id]'"); } mysql_query("DELETE FROM article_menu WHERE menu_id='$is_the_first_item_to_delete'"); } This will only delete the first sub items, however i would like to have all sub items to be deleted. I have searched this site but i couldn't find anything useful. This could be caused by my searching skills. Hopefully one of you scripters could help me out. ???