Basic Help Needed

djmac14

Hey hows it going? Okay so I am EXTREMELY new to PHP, as in, this my first venture into it haha. I have a lot of experience with HTML and CSS, so codings not new to me, just PHP. I have a pretty basic code I got from a "tutorial" site, that I am trying to alter to fit what I am trying to do. I'll give you as much detail as possible because I know thats very important in getting the help I need.

First off, I am building a search engine. But to search only fields I have input myself.

So I have page 1 which is "search.php". This is just a simple search form. It "GETS", and displays the results on "search_results.php".

I also have a mySQL table setup called "news". Which consists of:
ID: Int11, NOT NULL, Auto Increment, and Primary Key
Name: Varchar(255), NULL
Message: Varchar(255), NULL
Website: Varchar(255), NULL
Keywords: Varchar(255), NULL
Address: Varchar(255), NULL
Phone: Varchar(255), NULL

I want it to use Name, Message, and Keywords as the keywords. However, in the Search_results.php, I want "Keywords" omitted from the display, just used as a reference.

Now I've run into a couple problems. I had 1 very simple PHP code that was letting me display the results on "search_results.php", but it wasnt actually searching. It would just display everything that I had input into my tables.

So I went to a much more complex code (I know, the simple code wont work, so lets try an advanced one right?) I found on a tutorial site, and tried to edit to fit my criteria. But I end up with the error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/d/j/m/djmac14/html/mcpin/search_result2.php on line 37
Couldn't execute query

My line 37 is:

$row_num_links_main =mysql_num_rows ($numresults);

Here is the 2nd set of code I tried. Please if anyone can offer any help. I'm using this basically as my "introduction" to PHP, and damn its complex!

<?php
//connect to mysql

mysql_connect("dnserver","dbname","dbpass");
mysql_select_db("dbname");

//specify how many results to display per page
$limit = 10;

// Get the search variable from URL
$var = @$_GET['q'] ;
//trim whitespace from the stored variable
$trimmed = trim($var);
//separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
$resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
}
// check for a search parameter
if (!isset($var)){
$resultmsg = "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
}
// 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 news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords*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{
     $adid_array[] = $row[ 'id' ];
      }while( $row= mysql_fetch_array($numresults));
} //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){
$resultmsg ="<p>Search results for: ". $trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}
//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
?>

<form action="search2.php" method="get" name="search">
<div align="center">
<input name="q" type="text" value=" <?php echo $q; ?> " size="15">
<input name="search" type="submit" value="Search">
</div>
</form>

<?php
// display what the person searched for.
if( isset ($resultmsg)){
echo $resultmsg;
exit();
}else{
echo "Search results for: " . $var;
}

foreach($newarr as $value){
// EDIT HERE and specify your table and field names for the SQL query
$query_value = "SELECT FROMnews WHERE*keywords = '$value'";
$num_value=mysql_query ($query_value);
$row_linkcat= mysql_fetch_array ($num_value);
$row_num_links= mysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function.
//Replace field
$titlehigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'keywords' ] );
$linkhigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'name' ] );
$linkdesc = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'message' ] );
foreach($trimmed_array as $trimm){
if($trimm != 'b' ){
$titlehigh = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $titlehigh);
$linkhigh = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $linkhigh);
$linkdesc = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $linkdesc);
}
//end highlight
?>
<p>
<?php echo $titlehigh; ?><br>
<?php echo $linkhigh; ?><br>
<?php echo $linkhigh; ?>
</p>

<?php
} //end foreach $trimmed_array
if($row_num_links_main > $limit){
// next we need to do the links to other search result pages
if ($s>=1) { // do not display previous link if 's' is '0'
$prevs=($s-$limit);
echo "<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit. "</a></div>";
}
// check to see if last page
$slimit =$s+$limit;
if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {
// not last page so display next link
$n=$s+$limit;
echo "<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit. "</a></div>";
}
}
} //end foreach $newarr
?>

djmac14

I was getting the original error due to a Asterisk that made it into my code by mistake. I updated the original post with the real error, and the up to date php code

bradgrafelman

Look at your code again (and use the [PHP][/PHP] tags instead of just the CODE tags - the syntax highlighting makes it easier to read/analyze the code), specifically the MySQL query associated with the erring line.

You'll find that there is another asterisk in there (towards the end of the query). These asterisks appear here on the forums because the spaces you used (at least I'm assuming they looked like spaces to you in your original code) were not simple spaces (yes, there are multiple types of "spaces") and vBulletin replaces these special characters with asterisks.

djmac14

Hey thanks for the help. I just found those "*" and removed them. However I'm still getting my previously mentioned "Line 37" error. Here is the update to my code:

<?php
//connect to mysql

mysql_connect("xxxxxx","xxxxxxxx","xxxxxx"); 
mysql_select_db("xxxxx"); 

//specify how many results to display per page
$limit = 10;

// Get the search variable from URL
  $var = @$_GET['q'] ;
//trim whitespace from the stored variable
  $trimmed = trim($var);
//separate key-phrases into keywords
  $trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
  $resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
  }
// check for a search parameter
if (!isset($var)){
  $resultmsg =  "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
  }
// 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 news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords*DESC" ; 
     // Execute the query to  get number of rows that contain search keywords
     $numresults=mysql_query ($query) or die ( "Couldn't execute 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{
     $adid_array[] = $row[ 'id' ];
      }while( $row= mysql_fetch_array($numresults));
 } //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){
   $resultmsg ="<p>Search results for: ". $trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}
   //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
?>

<form action="search2.php" method="get" name="search">
  <div align="center">
     <input name="q" type="text" value=" <?php echo $q; ?> " size="15"> 
      <input name="search" type="submit" value="Search">
  </div>
</form>

<?php
// display what the person searched for.
 if( isset ($resultmsg)){
  echo $resultmsg;
  exit();
 }else{
  echo "Search results for: " . $var;
 }

foreach($newarr as $value){
 // EDIT HERE and specify your table and field names for the SQL query
$query_value = "SELECT  FROM news WHERE keywords = '$value'";
 $num_value=mysql_query ($query_value) or die ( "Couldn't execute query" );
 $row_linkcat= mysql_fetch_array ($num_value);
 $row_num_links= mysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function. 
//Replace field
  $titlehigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'keywords' ] );
  $linkhigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'name' ] );
  $linkdesc = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'message' ] );
foreach($trimmed_array as $trimm){
    if($trimm != 'b' ){
       $titlehigh = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $titlehigh);
       $linkhigh = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $linkhigh);
       $linkdesc = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $linkdesc); 
     }
//end highlight
?>
 <p>
<?php echo $titlehigh; ?><br>
<?php echo $linkhigh; ?><br>
<?php echo $linkhigh; ?>
</p>

<?php 
}   //end foreach $trimmed_array
   if($row_num_links_main > $limit){
   // next we need to do the links to other search result pages
     if ($s>=1) { // do not display previous link if 's' is '0'
          $prevs=($s-$limit);
          echo "<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit. "</a></div>";
     }
     // check to see if last page
     $slimit =$s+$limit;
         if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {
     // not last page so display next link
            $n=$s+$limit;
             echo "<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit. "</a></div>";
       }
    }
}  //end foreach $newarr
?>

I added in a couple " or die ( "Couldn't execute query" )" since I was using them later in the script, but not at the start.

dagon

     $query = "SELECT   FROM news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords*DESC" ;

should be

     $query = "SELECT *  FROM news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords*DESC" ;

or a list of fields

djmac14

lol I can't buy a break. I've been mulling over these forums for days trying to figure this PHP stuff out. You guys are F'in insane if you can just rattle this stuff off.

Fortunately that worked..... unfortunately now I just get the basic error of:

Couldn't execute query

Horizon88

remove die("couldn't execute query") and replace it with die(mysql_error()) please, so we can see what actual error is being generated.

djmac14

Horizon88 wrote:
remove die("couldn't execute query") and replace it with die(mysql_error()) please, so we can see what actual error is being generated.

Alright I did that and got:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC' at line 1

The mySQL database is version 4.1. However, I do have the option to use version 5.0

Here is my up to date code:

<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
//connect to mysql

mysql_connect("xxxx","xxxx","xxxx"); 
mysql_select_db("xxx"); 

//specify how many results to display per page
$limit = 10;

// Get the search variable from URL
  $var = @$_GET['q'] ;
//trim whitespace from the stored variable
  $trimmed = trim($var);
//separate key-phrases into keywords
  $trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
  $resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
  }
// check for a search parameter
if (!isset($var)){
  $resultmsg =  "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
  }
// 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 news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords*DESC" ; 
     // Execute the query to  get number of rows that contain search keywords
     $numresults=mysql_query ($query) or die(mysql_error());
     $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 s" );
     $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{
     $adid_array[] = $row[ 'id' ];
      }while( $row= mysql_fetch_array($numresults));
 } //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){
   $resultmsg ="<p>Search results for: ". $trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}
   //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
?>

<form action="search2.php" method="get" name="search">
  <div align="center">
     <input name="q" type="text" value=" <?php echo $q; ?> " size="15"> 
      <input name="search" type="submit" value="Search">
  </div>
</form>

<?php
// display what the person searched for.
 if( isset ($resultmsg)){
  echo $resultmsg;
  exit();
 }else{
  echo "Search results for: " . $var;
 }

foreach($newarr as $value){
 // EDIT HERE and specify your table and field names for the SQL query
$query_value = "SELECT * FROM*news WHERE*keywords = '$value'";
 $num_value=mysql_query ($query_value) or die(mysql_error());
 $row_linkcat= mysql_fetch_array ($num_value);
 $row_num_links= mysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function. 
//Replace field
  $titlehigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'keywords' ] );
  $linkhigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'name' ] );
  $linkdesc = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'message' ] );
foreach($trimmed_array as $trimm){
    if($trimm != 'b' ){
       $titlehigh = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $titlehigh);
       $linkhigh = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $linkhigh);
       $linkdesc = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $linkdesc); 
     }
//end highlight
?>
 <p>
<?php echo $titlehigh; ?><br>
<?php echo $linkhigh; ?><br>
<?php echo $linkhigh; ?>
</p>

<?php 
}   //end foreach $trimmed_array
   if($row_num_links_main > $limit){
   // next we need to do the links to other search result pages
     if ($s>=1) { // do not display previous link if 's' is '0'
          $prevs=($s-$limit);
          echo "<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit. "</a></div>";
     }
     // check to see if last page
     $slimit =$s+$limit;
         if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {
     // not last page so display next link
            $n=$s+$limit;
             echo "<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit. "</a></div>";
       }
    }
}  //end foreach $newarr
?>
   </body>
</html>

NogDog

You have spurious asterisks in your query strings, again.

djmac14

NogDog wrote:
You have spurious asterisks in your query strings, again.

God damn, I'm sorry. Its from going back and forth from forum to Dreamweaver and back. Ok, so I went through got rid of the "*"'s and I dont get any mySQL errors! Hurray!

Now I get:

Search Error

We don't seem to have a search parameter!

When I do have have a keyword entered, unless keyword does not mean parameter. Heres is my up to date code:

<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
//connect to mysql

mysql_connect("xxxx","xxxx","xxx"); 
mysql_select_db("xxxx"); 

//specify how many results to display per page
$limit = 10;

// Get the search variable from URL
  $var = @$_GET['q'] ;
//trim whitespace from the stored variable
  $trimmed = trim($var);
//separate key-phrases into keywords
  $trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
  $resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
  }
// check for a search parameter
if (!isset($var)){
  $resultmsg =  "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
  }
// 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 news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords DESC" ; 
     // Execute the query to  get number of rows that contain search keywords
     $numresults=mysql_query ($query) or die(mysql_error());
     $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 s" );
     $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{
     $adid_array[] = $row[ 'id' ];
      }while( $row= mysql_fetch_array($numresults));
 } //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){
   $resultmsg ="<p>Search results for: ". $trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}
   //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
?>

<form action="search2.php" method="get" name="search">
  <div align="center">
     <input name="q" type="text" value=" <?php echo $q; ?> " size="15"> 
      <input name="search" type="submit" value="Search">
  </div>
</form>

<?php
// display what the person searched for.
 if( isset ($resultmsg)){
  echo $resultmsg;
  exit();
 }else{
  echo "Search results for: " . $var;
 }

foreach($newarr as $value){
 // EDIT HERE and specify your table and field names for the SQL query
$query_value = "SELECT * FROM news WHERE keywords = '$value'";
 $num_value=mysql_query ($query_value) or die(mysql_error());
 $row_linkcat= mysql_fetch_array ($num_value);
 $row_num_links= mysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function. 
//Replace field
  $titlehigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'keywords' ] );
  $linkhigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'name' ] );
  $linkdesc = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'message' ] );
foreach($trimmed_array as $trimm){
    if($trimm != 'b' ){
       $titlehigh = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $titlehigh);
       $linkhigh = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $linkhigh);
       $linkdesc = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $linkdesc); 
     }
//end highlight
?>
 <p>
<?php echo $titlehigh; ?><br>
<?php echo $linkhigh; ?><br>
<?php echo $linkhigh; ?>
</p>

<?php 
}   //end foreach $trimmed_array
   if($row_num_links_main > $limit){
   // next we need to do the links to other search result pages
     if ($s>=1) { // do not display previous link if 's' is '0'
          $prevs=($s-$limit);
          echo "<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit. "</a></div>";
     }
     // check to see if last page
     $slimit =$s+$limit;
         if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {
     // not last page so display next link
            $n=$s+$limit;
             echo "<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit. "</a></div>";
       }
    }
}  //end foreach $newarr
?>
   </body>
</html>

dagon

ergo $var is not set -- $_GET['q'] is not set the url submited should have ?q=SUUBMITED TEXT (from the form)

djmac14

You guys are the shit. However, its not quite done. The search works. If I search for something completely random I get the "Your search returned zero results" message. If I search for something I know that exists within my mySQL table I get:

Search results for: whatever keyword

Then no results. So I know its finding the information, or else it would tell me it found nothing, it just wont display it. I looked at the portion that displays what the user search for, however I dont see anything to my knowledge that would prevent the results from showing. Could the problem be in my mySQL table?

djmac14

Anyone know why the results wont display? I've been looking at the code trying a few things but for some reason the Display Results portion of the code doesnt seem to be working.
Heres my current code:

<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
//connect to mysql

mysql_connect("xxxx","xxxx","xxx"); 
mysql_select_db("xxxx"); 

//specify how many results to display per page
$limit = 10;

// Get the search variable from URL
  $var = @$_GET['q'] ;
//trim whitespace from the stored variable
  $trimmed = trim($var);
//separate key-phrases into keywords
  $trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.
if ($trimmed == "") {
  $resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;
  }
// check for a search parameter
if (!isset($var)){
  $resultmsg =  "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
  }
// 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 news WHERE keywords LIKE '%$trimm%' OR name like '%$trimm%' OR message like '%$trimm%' ORDER BY keywords DESC" ; 
     // Execute the query to  get number of rows that contain search keywords
     $numresults=mysql_query ($query) or die(mysql_error());
     $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 s" );
     $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{
     $adid_array[] = $row[ 'id' ];
      }while( $row= mysql_fetch_array($numresults));
} //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){
   $resultmsg ="<p>Search results for: ". $trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}
   //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
?>

<form action="search2.php" method="get" name="search">
  <div align="center">
     <input name="q" type="text" value=" <?php echo $q; ?> " size="15"> 
      <input name="search" type="submit" value="Search">
  </div>
</form>

<?php
// display what the person searched for.
if( isset ($resultmsg)){
  echo $resultmsg;
  exit();
}else{
  echo "Search results for: " . $var;
}

foreach($newarr as $value){
// EDIT HERE and specify your table and field names for the SQL query
$query_value = "SELECT * FROM news WHERE keywords = '$value'";
$num_value=mysql_query ($query_value) or die(mysql_error());
$row_linkcat= mysql_fetch_array ($num_value);
$row_num_links= mysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function. 
//Replace field
  $titlehigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'keywords' ] );
  $linkhigh = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'name' ] );
  $linkdesc = preg_replace ( "'($var)'si" , "<b> //1</b>" , $row_linkcat[ 'message' ] );
foreach($trimmed_array as $trimm){
    if($trimm != 'b' ){
       $titlehigh = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $titlehigh);
       $linkhigh = preg_replace( "'($trimm)'si" , "<b> //1</b>" , $linkhigh);
       $linkdesc = preg_replace( "'($trimm)'si" ,  "<b> //1</b>" , $linkdesc); 
     }
//end highlight
?>
<p>
<?php echo $titlehigh; ?><br>
<?php echo $linkhigh; ?><br>
<?php echo $linkhigh; ?>
</p>

<?php 
}   //end foreach $trimmed_array
   if($row_num_links_main > $limit){
   // next we need to do the links to other search result pages
     if ($s>=1) { // do not display previous link if 's' is '0'
          $prevs=($s-$limit);
          echo "<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit. "</a></div>";
     }
     // check to see if last page
     $slimit =$s+$limit;
         if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {
     // not last page so display next link
            $n=$s+$limit;
             echo "<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit. "</a></div>";
       }
    }
}  //end foreach $newarr
?>
   </body>
</html>