Come posso ciclare più query senza che vadano in conflitto tra loro ??? Questo e il codice che uso ma ovviamente e sbagliato....
PHP:
function option_category_id(){
global $html;
$html = '';
DB::select( '*', 'terms', 'parent="0"' );
if( DB::$result && DB::num() > 0 ){
while ( $obj = DB::obj() ) {
$id = $obj->ID;
$name = $obj->name;
$html .= '<option value="'.$id.'">'.$name.'</option>';
option_category_id_2( $id );
}
}
return $html;
}
function option_category_id_2( $id ){
global $html, $level;
if( ! isset( $level ) )
$level = '- ';
else
$level .= '- ';
DB::select( '*', 'terms', 'parent="'.$id.'"' );
if( DB::$result && DB::num() > 0 ){
while ( $obj = DB::obj() ) {
$id = $obj->ID;
$name = $obj->name;
$html .= '<option value="'.$id.'">'.$level.$name.'</option>';
option_category_id_2( $id );
}
}
}