0"; foreach ($conn->query($sql) as $totalcount) { //echo $totalcount['0'] ; }; $numrows = $totalcount['0'] ; $sql = "SELECT * FROM parts WHERE supp = 'ETRS' AND qty>0 ORDER BY part1 LIMIT $offset, $rowsPerPage"; $maxPage = ceil($totalcount['0']/$rowsPerPage); $self = $_SERVER['PHP_SELF']; ?> Euro-Tech Export | Parts Listing UK Stock Holding

Parts Listing - UK Stocked Specials

Click the product to see more details.

query($sql) as $row) { ?> .o0O0o." ;?>
SELECT PART MANUFACTURER QTY
class="btn btn-default-transparent btn-hvr hvr-shutter-out-horizontal" role="button">Select " .$row['part2'] .""; //urlencode() is used to allow 'illegal characters' in part number such a hash # symbol?>

Records found matching

$numrows) { echo "
Record $offsetx to $numrows of $numrows

"; } else echo "
Record $offsetx to $offsety of $numrows

"; // creating 'previous' and 'next' link // plus 'first page' and 'last page' link // print 'previous' link only if we're not // on page one if ($pageNum > 1) { $page = $pageNum - 1; /* $prev = " [Prev] "; */ $prev = "
  • "; /*$first = " [First Page] "; */ $first = "
  • "; } else { $prev = "
  • "; // we're on page one, don't enable 'previous' link $first = "
  • "; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; /* $next = " [Next] "; */ /* $next = " [Next] "; */ $next = "
  • "; $last = "
  • "; /* $last = " [Last Page] "; */ } else { $next = '
  • '; // we're on the last page, don't enable 'next' link $last = '
  • '; // nor 'last page' link } // end else ?>