"; $db->dbConnect(); $query = $cmd; echo "Dropping Indexes...
\n"; $db->dbQuery( "alter table DataTabletxt drop index ft_first_heading"); $db->dbQuery( "alter table DataTabletxt drop index ft_second_heading"); $db->dbQuery( "alter table DataTabletxt drop index ft_summary_title"); $db->dbQuery( "alter table DataTabletxt drop index ft_title_abstract"); echo "Indexes Dropped.
\n"; echo "Creating Indexes...
\n"; $db->dbQuery( "alter table DataTabletxt add fulltext ft_title_abstract(title, abstract)"); $db->dbQuery( "alter table DataTabletxt add fulltext ft_first_heading(first_heading)"); $db->dbQuery( "alter table DataTabletxt add fulltext ft_second_heading(second_heading)"); $db->dbQuery( "alter table DataTabletxt add fulltext ft_summary_title(summary_title)"); echo "Indexes Created.
\n"; $query = "show index from DataTabletxt"; $db->dbQuery( $query ); $resultCount = $db->resultCount(); echo "\n"; while( $resultArray[] = mysql_fetch_assoc( $db->sqlHandle ) ){ }// create loop to load resultArray echo ""; foreach( $resultArray[0] as $key => $value ) { echo "\n"; } echo ""; for ( $i=0; $i<$resultCount; $i++ ) { echo ""; foreach( $resultArray[$i] as $value ) { echo "\n"; } echo ""; } echo "
" . $key . "
" . $value . "
\n"; $db->dbClose(); echo "
"; ?>