Hi All,

I have this search code for a library. however I have the same script in 2
different files, one with just search script and another with the
pagination. But when I combined it its giving me few errors. I am getting
the below errors.


*Notice*: Undefined index: start in *C:\wamp\www\search with
pagenatation\search.php* on line *12*

*Notice*: Undefined variable: x in *C:\wamp\www\search with
pagenatation\search.php* on line *41*

*Notice*: Undefined variable: construct in *C:\wamp\www\search with
pagenatation\search.php* on line *43*

*Warning*: mysql_num_rows() expects parameter 1 to be resource, boolean
given in *C:\wamp\www\search with pagenatation\search.php* on line *56*

No results found.

****************************************************************************************************************
*

Here is the search.php code:*

<?PHP

@mysql_connect("localhost","root","") or die("couldn't connect");
@mysql_select_db("search") or die("couldn't select database.");

// max displayed per page
$per_page = 1;

//get data
$button = $_GET['submit'];
$search = $_GET['search'];
$start  = $_GET['start'];

// count records
$record_count = mysql_num_rows(mysql_query("SELECT * FROM search"));

//count max pages
$max_pages = ceil($record_count /  $per_page); // may come out as decimal

if (!$start)
   $start = 0;

if ($button=0)//or try ==0  its bean a long time
        echo "<code><br> You didn't submit a keyword.</code>";
else
{
   if (strlen($search)<=2)
      echo "<code style='width: 100%;'><br> Search term too short.</code>";
   else
   {
        echo "<code>You searched for <b>$search</b></code>";


               //explode our search term
               $search_exploded = explode(" ",$search);

               foreach($search_exploded as $search_each)
               {

                  //construct query
                  $x++;
                  if ($x==1)
                     $construct .= "keywords LIKE '%$search_each%'";
                  else
                     $construct .= " OR keywords LIKE '%$search_each%'";

               }



         //echo out construct

         $construct = "SELECT * FROM search WHERE $construct LIMIT $start,
$per_page";
         $run = mysql_query($construct);

         $foundnum = mysql_num_rows($run);

        echo $foundnum;

         if ($foundnum==0)
            echo "<code><br> No results found.</code>";
         else
         {
            echo "<code> $foundnum results found!</code>";

            while ($runrows = mysql_fetch_assoc($run))
            {
             //get data

             $title = $runrows['title'];
             $desc = $runrows['desc'];
             $key = $runrows['keywords'];
             $url = $runrows['url'];

             echo "
<table class='search-results'>
        <tr>

                <td>
                <p id='headline'>Game: <a href='$url'>$title</a></p>
                <p id='descript'>$desc</p>
               <p id='tags'>Tags: $key</p>
                </td>
        </tr>
</table>
             ";

            }
                        // setup navagation
$prev = $start - $per_page;
$next = $start + $per_page;

// prev button
if(!($start<=0))
        echo " <a href='search.php?search=$search&start=$prev'>Prev</a> ";



// show page numbers

//set variable for first page
$i=1;

for ($x=0;$x<$max_pages;$x=$x+$per_page)
{
        if ($start!=$x)
                echo " <a href='search.php?search=$search&start=$x'>$i</a>
";
        else
                echo " <a
href='search.php?search=$search&start=$x'><b>$i</b></a> ";
        $i++;
}



/*for ($x=0;$x<$record_count;$x=$x+$per_page)
{
        if ($start!=$x)
                echo " <a href='search.php?search=$search&start=$x'>$i</a>
";
        else
                echo " <a
href='search.php?search=$search&start=$x'><b>$i</b></a> ";
        $i++;
}
*/

// next button
if(!($start>=$record_count-$per_page))
echo " <a href='search.php?search=$search&start=$next'>Next</a> ";

         }



   }
}


?>




-- 
*Best,
*
*Guru™*

Reply via email to