<?php
if($_GET['action'] == "search") {
  $var = $_POST['q'] ;
  $trimmed = trim($var);
    $host = "localhost";
    $db = "database";
    $usr = "user";
    $pss = "password";
$limit=1; 
if (!$trimmed)
  {
  echo "<p>Please enter the 10 digit Member ID</p>";
  exit;
  }

if (!isset($var))
  {
  echo "<p>You MUST enter the 10 digit Member ID</p>";
  exit;
  }

mysql_connect($host,$usr,$pss); 

mysql_select_db($db) or die("Unable to select database"); 

$query = "select * from users where fldID = '$trimmed' order by fldID"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);


if ($numrows == 0)
  {
  echo "<h4>Search</h4>";
  echo "<p>Member ID: &quot;" . $trimmed . "&quot; is NOT valid</p>";

  if (empty($s)) {
  $s=0;
  }

  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

echo "<p>Member ID: &quot;" . $var . "&quot;</p>";

echo "Member Name";


  while ($row= mysql_fetch_array($result)) {
  $Name = $row["fldName"];
  $address = $row["fldAddress"];
  $Id = $row["fldExp"];
  $status = $row["fldStatus"];

  echo "$count:&nbsp;$Name<br>Id Number: $Id<br>Address: $address<br>Status: $status<br>" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

  echo "<br />";

  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

  $pages=intval($numrows/$limit);


  if ($numrows%$limit) {
  $pages++;
  }

  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;

  if ($a > $numrows) { $a = $numrows ; }

  $b = $s + 1 ;

  echo "<p>Showing results $b to $a of $numrows</p>";

  }

} 

?>