0 ) { $query = " update category_hierarchy " . " set category_id = " . $_POST[ 'select_category_id' ] . " where sub_category_id = " . $_POST[ 'sub_category_id' ]; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); } if( strlen( $_POST[ 'delete_category' ] ) > 0 ) { $query = " delete from category_hierarchy " . " where category_id = " . $_POST[ 'sub_category_id' ] . " or sub_category_id = " . $_POST[ 'sub_category_id' ]; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); $query = " delete from category " . " where category_id = " . $_POST[ 'sub_category_id' ]; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); } function selectAllCategoryEdit( $iCategoryID ) { include 'category_insert.inc'; /* Performing SQL query */ $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 ". " and ch.category_id = 0 " . " order by category_name"; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); $i = 0; while( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) { $sCategoryID[ $i ] = $row[ 'category_id' ]; $sCategoryName[ $i ] = $row[ 'category_name' ]; $sSubCategoryID[ $i ] = $row[ 'sub_category_id' ]; $i++; } print "\n"; /* Performing SQL query */ $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 ". " and ch.category_id = " . $iCategoryID . //" and ch.category_id = 0 " . " order by category_name limit 15"; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); print ''; while( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) { print ''; print ''; print ''; print ''; print ''; print ''; print ''; print "\n"; print ''; } print '

'; print "\n"; print ''; print ''; print $row[ 'category_name' ]; print ' - ' . $row[ 'category_id' ]; print ' - ' . $row[ 'sub_category_id' ]; print '

'; print ''; $i = 0; while( strlen( $sCategoryID[ $i ] ) > 0 ) { $sSelected = ''; if( $row[ 'category_id' ] == 1 ) { //alert( ' cat_id: ' . $row[ 'sub_category_id' ] . 'cat_id: ' . $sSubCategoryID[ $i ] ); } if( $row[ 'category_id' ] == $sSubCategoryID[ $i ] ) { $sSelected = 'selected'; } print ''; print $sCategoryName[ $i ] . ' - ' . $sCategoryID[ $i ] . ' - ' . $sSubCategoryID[ $i ]; print ''; $i++; } print ''; print '

'; print ''; print '

'; print 'delete '; print '

' . "\n"; /* Free resultset */ mysql_free_result($result); } function selectAllCategoryNew( $iCategoryID ) { /* Performing SQL query */ $query = " SELECT * " . " FROM category c, " . " category_hierarchy ch " . " where c.adult <> 'yes' " . " and c.category_id = ch.sub_category_id ". " and ch.category_id = " . $iCategoryID . " and ch.sub_category_id <> 461 " . " order by category_name"; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); print ''; print "\n"; print ''; $i = 0; $iMaxRow = 5; while( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) { if( $i == 0 ) { print ''; } if( $i == $iMaxRow ) { $i = 0; } else { $i++; } //$iCategoryID = $row[ "category_id" ]; } print ''; print "\n"; print "

'; } print "\n"; print ''; print "\n"; print ''; print $row["category_name"]; print ''; print ''; /* Performing SQL query */ $sSubCatQuery = " SELECT * " . " FROM category c, " . " category_hierarchy ch " . " where c.adult <> 'yes' " . " and c.category_id = ch.sub_category_id ". " and ch.category_id = " . $row[ 'sub_category_id' ] . " order by category_name"; //print 'sSubCatQuery: ' . $sSubCatQuery . ' '; $rSubCatResult = mysql_query($sSubCatQuery) or die("sSubCatQuery failed"); print ' '; print ''; print ''; print ''; print ''; print ' '; print ''; $j = 0; $iMaxCol = 1; while( $dSubCatRow = mysql_fetch_array($rSubCatResult, MYSQL_ASSOC) and $j <= $iMaxCol ) { $sNoSubCats = ''; print substr( $dSubCatRow[ 'category_name' ], 0, 15 ); print ', '; if( $j == $iMaxCol ) { print '...'; } $j++; } print ''; print ' '; print ' '; if( $i == $iMaxRow ) { print '

\n"; /* Free resultset */ mysql_free_result($result); } function insertURL($URLID,$categoryID) { if( $URLID > 0 ) { $url[0] = 'url_id'; $url[1] = 'category_id'; $url_value[0] = $URLID; $url_value[1] = $categoryID; //disabling until registration is in place //insertValues( 'assoc_website_category', $url, $url_value ); } } function selectAllCategory() { /* Performing SQL query */ $query = "SELECT * FROM category where adult <> 'yes' order by category_name"; //print 'query: ' . $query . '
'; $result = mysql_query($query) or die("Query failed"); print ''; print "\n"; while( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) { print ''; print ''; print "\n"; $iCategoryID = $row[ 'category_id' ]; } print "

'; print "\n"; print ''; print "\n"; print ''; print $row["category_name"]; print ''; print ''; print '

\n"; /* Free resultset */ mysql_free_result($result); } ?>