Simple database search problem

[mariahoeppner]

I'm trying to setup a simple database search, however when I test the page, the
search yields all the records in the database. Connection to MySQL database is
working. I have a search page with a simple html form using GET and then a PHP
page for the results. It's as if the database isn't recognizing the search
parameter??? I'm new to working with dynamic pages, so any advice would be
appreciated! Thanks in advance...

[tecknowjnkie]

Can you post your code?


both the form code and the .php page

[mariahoeppner]

Form Code:

<form action="interchangeresults.php" method="get"
enctype="application/x-www-form-urlencoded" name="search" id="search">
<input name="searchkey" type="text" id="searchkey">
<INPUT name="Searchbut" TYPE="submit" id="Searchbut" VALUE="Search">
</form>

PHP:

<?php require_once('Connections/connSBI.php'); ?>
<?php
$maxRows_rsResults = 50;
$pageNum_rsResults = 0;
if (isset($_GET['pageNum_rsResults'])) {
$pageNum_rsResults = $_GET['pageNum_rsResults'];
}
$startRow_rsResults = $pageNum_rsResults * $maxRows_rsResults;

mysql_select_db($database_connSBI, $connSBI);
$query_rsResults = "SELECT * FROM Interchange WHERE PartNo LIKE '%s' OR Comp
LIKE '%s' OR CompPartNo LIKE '%s' ORDER BY PartNo ASC";
$query_limit_rsResults = sprintf("%s LIMIT %d, %d", $query_rsResults,
$startRow_rsResults, $maxRows_rsResults);
$rsResults = mysql_query($query_limit_rsResults, $connSBI) or
die(mysql_error());
$row_rsResults = mysql_fetch_assoc($rsResults);

if (isset($_GET['totalRows_rsResults'])) {
$totalRows_rsResults = $_GET['totalRows_rsResults'];
} else {
$all_rsResults = mysql_query($query_rsResults);
$totalRows_rsResults = mysql_num_rows($all_rsResults);
}
$totalPages_rsResults = ceil($totalRows_rsResults/$maxRows_rsResults)-1;
?>