" />
"; $items = get_row_count( "SELECT COUNT(*) FROM {$pre}faq WHERE ( category = '{$row[id]}' )" ); $subcats = get_row_count( "SELECT COUNT(*) FROM {$pre}faq WHERE ( parent = '{$row[id]}' )" ); echo ""; } echo "
{$data[header]}

{$LANG[faq_main_category]} < {$LANG[faq_parent_category]} | "; ?> ''

"; $i = 0; while( $row = mysql_fetch_array( $res ) ) { if( $i++ % 2 == 0 ) echo "
" . field( $row[description] ) . " ($subcats {$LANG[faq_subcategories]}, $items {$LANG[faq_entries]})

" . ((trim( $row[symptoms] ) != "") ? field( $row[symptoms] ) : "{$LANG[faq_no_description]}") . "
"; if( $i % 2 == 1 ) echo "

"; } $res = mysql_query( "SELECT id, description FROM {$pre}faq WHERE ( category = '{$_POST[parent]}' ) ORDER BY date DESC" ); if( mysql_num_rows( $res ) ) { echo ""; $res = mysql_query( "SELECT id, description FROM {$pre}faq WHERE ( category = '{$_POST[parent]}' )" ); while( $row = mysql_fetch_array( $res ) ) { $bgcolor = ($bgcolor == "#DDDDDD") ? "#EEEEEE" : "#DDDDDD"; echo ""; } echo "
" . field( $row[description] ) . "
"; } } else if( $_POST[cmd] == "view" ) { $res = mysql_query( "SELECT * FROM {$pre}faq WHERE ( id = '{$_GET[id]}' ) ORDER BY date DESC" ); $row = mysql_fetch_array( $res ); echo "<< {$LANG[faq_main_category]} < {$LANG[faq_parent_category]}

"; echo "
" . field( $row[description] ) . "

"; echo "{$LANG[faq_symptoms]}
"; if( trim( $row[symptoms] ) == "" ) echo "{$LANG[faq_no_symptoms]}"; else echo parse_tags( $row[symptoms] ); echo "

{$LANG[faq_solution]}
"; if( trim( $row[solution] ) == "" ) echo "{$LANG[faq_no_solution]}"; else echo parse_tags( $row[solution] ); } else if( $_POST[cmd] == "search" ) { echo "{$LANG[faq_categories]}

"; $res = mysql_query( "SELECT * FROM {$pre}faq WHERE ( description LIKE '%{$_GET[search]}%' || symptoms LIKE '%{$_GET[search]}%' || solution LIKE '%{$_GET[search]}%' ) ORDER BY date DESC" ); if( !mysql_num_rows( $res ) ) echo "{$LANG[faq_no_results]}"; else { echo ""; while( $row = mysql_fetch_array( $res ) ) { $res_cat = mysql_query( "SELECT description FROM {$pre}faq WHERE ( id = '{$row[category]}' )" ); $row_cat = mysql_fetch_array( $res_cat ); $bgcolor = ($bgcolor == "#DDDDDD") ? "#EEEEEE" : "#DDDDDD"; echo ""; } echo "
" . field( $row[description] ) . "" . ((trim( $row_cat[description] ) != "") ? "  [{$row_cat[description]}]" : "") . "
"; } } /********************************************************** PHP */?>
{$data[footer]}