Pagination Error

[Boudga]

I'm trying to get pagination working but keep getting this error msg:

Error: 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 'Resource id #3' at line 1

Why????

myScript below:

<?php 

@mysql_connect("127.0.0.1", "client", "") or die("ERROR--CAN'T CONNECT TO SERVER");  

@mysql_select_db("Military_Catalog") or die("ERROR--CAN'T CONNECT TO DB"); 


$query_count    = "SELECT count(*) FROM partslist";  

$result_count   = mysql_query($query_count);     

$totalrows  = mysql_num_rows($result_count);
$limit=25; // rows to return     

if(empty($page)){    // Checks if the $page variable is empty (not set) 
        $page = 1;      // If it is empty, we're on page 1 
} 

$limitvalue = $page * $limit - ($limit); 

$str1="$input";
$str1 = addslashes($str1); 

$query = mysql_query(" SELECT *
FROM partslist 
WHERE `partnum`  

LIKE '%$input%' OR `nsn`  

LIKE '%$input%' OR `description`  

LIKE '%$input%' OR `top_level_kit`  

LIKE '%$input%' OR `eng_used_on`  

LIKE '%$input%' 
ORDER BY `partnum` ASC 
LIMIT $limitvalue, $limit"         

);

$result = mysql_query($query) or die("Error: " . mysql_error()); 
    // Selects all the data from table. 
    // mysql_error() will print an error if one occurs. 

if(mysql_num_rows($result) == 0){ 
        echo("Nothing to Display!"); 
    } 

while ($row = mysql_fetch_array($result)) {
	$partnum = $row["partnum"];
	$nsn = $row["nsn"];	
	$top_level_kit = $row["top_level_kit"];
	$description = $row["description"];	
	$eng_used_on = $row["eng_used_on"];                                                                                                                                  

echo"
<a href=\"http://www.atec.com/db_any_query.php\"><span style=\"font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-size: 11px; color: #444973; \">Return to NSN Query</span></a><br />		
<span style=\"font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-size: 11px; color: #444973; \">Part Number:</span> <span style=\" font: 9px verdana,arial; color:#717abf; font-weight: bold;\">$partnum</span><br />
<span style=\"font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-size: 11px; color: #444973; \">NSN:</span> <span style=\" font: 9px verdana,arial; color:#717abf; font-weight: bold;\">$nsn</span><br />
<span style=\"font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-size: 11px; color: #444973; \">Description:</span> <span style=\" font: 9px verdana,arial; color:#717abf; font-weight: bold;\">$description</span><br />
<span style=\"font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-size: 11px; color: #444973; \">Top Level Kit:</span> <span style=\" font: 9px verdana,arial; color:#717abf; font-weight: bold;\">$top_level_kit</span><br />
<span style=\"font-family: Verdana, Geneva, Arial, helvetica, sans-serif; font-size: 11px; color: #444973; \">Engine Used On:</span> <span style=\" font: 9px verdana,arial; color:#717abf; font-weight: bold;\">$engine_used_on</span> <br />

<hr noshade SIZE=1 color=#717abf>
";
   }; 
if($page != 1){ 
        $pageprev = $page--; 

echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a>&nbsp;");           

}else 
        echo("PREV".$limit."&nbsp;"); 

$numofpages = $totalrows / $limit; 

for($i = 1; $i <= $numofpages; $i++){ 
    /* This for loop will add 1 to $i at the end of each pass until $i is greater 
than $numofpages (4.08). */ 

    if($i == $page){ 
        echo($i."&nbsp;"); 
    }else{ 
        echo("<a href=\"$PHP_SELF&page=$i\">$i</a>&nbsp;"); 
    } 
}

if(($totalrows % $limit) != 0){ 

    if($i == $page){ 
        echo($i."&nbsp;"); 
    }else{ 
        echo("<a href=\"$PHP_SELF&page=$i\">$i</a>&nbsp;"); 
    } 

}

  if(($totalrows - ($limit * $page)) > 0){ 

    $pagenext   = $page++; 
    // Fancy way of adding 1 to page 

    echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>"); 
    /* Since there are pages remaining, this outputs NEXT in link form. */ 
}else{ 
    echo("NEXT".$limit); 

} 

mysql_free_result($result); 

?> 

[YappyDog]

Try using this format (as shown in the manual examples)........

$connection = mysql_connect($host, $user, $pass);
$db = mysql_select_db($mydatabase, $connection);

http://us4.php.net/manual/en/function.mysql-select-db.php