Please enter a search...
" ; } // check for a search parameter if (!isset($var)){ $resultmsg = "Search Error
We don't seem to have a search parameter!
" ; } // Build SQL Query for each keyword entered foreach ($trimmed_array as $trimm){ // EDIT HERE and specify your table and field names for the SQL query $query = "SELECT * FROM Etym WHERE roots = '$trimm' OR prefixes = '$trimm' OR suffixes = '$trimm' ORDER BY roots DESC"; // Execute the query to get number of rows that contain search kewords $numresults=mysql_query ($query); $row_num_links_main=mysql_num_rows($numresults); // next determine if 's' has been passed to script, if not use 0. // 's' is a variable that gets set as we navigate the search result pages. if (empty($s)) { $s=0; } // now let's get results. $query .= " LIMIT $s,$limit" ; $numresults = mysql_query ($query) or die ( "Couldn't execute query" ); $row= mysql_fetch_array ($numresults); //store record id of every item that contains the keyword in the array we need to do this to avoid display of duplicate search result. do{ //EDIT HERE and specify your field name that is primary key $adid_array[] = $row[ 'ID' ]; }while( $row= mysql_fetch_array($numresults)); } //end foreach if($row_num_links_main == 0 && $row_set_num == 0){ $resultmsg = "Search results for:" . $trimmed ."
Sorry, your search returned zero results
" ; } //delete duplicate record id's from the array. To do this we will use array_unique function $tmparr = array_unique($adid_array); $i=0; foreach ($tmparr as $v) { $newarr[$i] = $v; $i++; } // now you can display the results returned. But first we will display the search form on the top of the page ?> \\1" , $row_linkcat[ 'roots' ] ); $linkhigh = preg_replace ( "'($var)'si" , "\\1" , $row_linkcat[ 'prefixes' ] ); $linkdesc = preg_replace ( "'($var)'si" , "\\1" , $row_linkcat[ 'suffixes' ] ); foreach($trimmed_array as $trimm){ if($trimm != 'b' ){ //IF you added more fields to search make sure to add them below as well. $titlehigh = preg_replace( "'($trimm)'si" , "\\1" , $titlehigh); $linkhigh = preg_replace( "'($trimm)'si" , "\\1" , $linkhigh); $linkdesc = preg_replace( "'($trimm)'si" , "\\1" , $linkdesc); } //end highlight ?>