0 ) { $query = " insert into category " . " ( category_name ) " . " values ( '" . $_POST[ 'insert_category_name' ] . "' )"; print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); $iInsertID = mysql_insert_id(); $iParentCategoryID = 0; if( strlen( $_POST[ 'select_parent_category_id' ] ) > 0 ) { $iParentCategoryID = $_POST[ 'select_parent_category_id' ]; } $query = " insert into category_hierarchy " . " ( category_id, sub_category_id ) " . " values ( " . $iParentCategoryID . ", " . $iInsertID . " )"; print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); } $query = " SELECT ch.category_id, " . " c.category_name, " . " ch.sub_category_id " . " FROM category c, " . " category_hierarchy ch " . " where c.adult <> 'yes' " . " and c.category_id = ch.sub_category_id ". " order by category_name"; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); print ''; print ''; print ''; print ''; print ''; print "\n"; print ''; print ''; print ''; print ''; print ''; print ''; print '

'; print ''; print ''; print 'empty'; print ''; while( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) { print ''; print $row[ 'category_name' ]; print ''; $i++; } print ''; print '

'; print ''; print '

'; print ''; print '

' . "\n"; print ''; print '
'; print '
'; ?>