this error keeps comming up with my next and previous buttons:
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 'like '%%' LIMIT 10, 10' at line 1
This is my code(please somebody help):
<?php require_once('Connections/canada_search.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_search = 10;
$pageNum_search = 0;
if (isset($HTTP_GET_VARS['pageNum_search'])) {
$pageNum_search = $HTTP_GET_VARS['pageNum_search'];
}
$startRow_search = $pageNum_search * $maxRows_search;
mysql_select_db($database_canada_search, $canada_search);
$query_search = "select * from search where ".$category." like '%".$term."%'";
$query_limit_search = sprintf("%s LIMIT %d, %d", $query_search, $startRow_search, $maxRows_search);
$search = mysql_query($query_limit_search, $canada_search) or die(mysql_error());
$row_search = mysql_fetch_assoc($search);
if (isset($HTTP_GET_VARS['totalRows_search'])) {
$totalRows_search = $HTTP_GET_VARS['totalRows_search'];
} else {
$all_search = mysql_query($query_search);
$totalRows_search = mysql_num_rows($all_search);
}
$totalPages_search = ceil($totalRows_search/$maxRows_search)-1;
$queryString_search = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_search") == false &&
stristr($param, "totalRows_search") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_search = "&" . implode("&", $newParams);
}
}
$queryString_search = sprintf("&totalRows_search=%d%s", $totalRows_search, $queryString_search);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p> </p>
<table width="400" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td> </td>
<td align="center">
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center"> <?php if ($pageNum_search > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage, 0, $queryString_search); ?>">First</a>
<?php } // Show if not first page ?> </td>
<td width="31%" align="center"> <?php if ($pageNum_search > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage, max(0, $pageNum_search - 1), $queryString_search); ?>">Previous</a>
<?php } // Show if not first page ?> </td>
<td width="23%" align="center"> <?php if ($pageNum_search < $totalPages_search) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage, min($totalPages_search, $pageNum_search + 1), $queryString_search); ?>">Next</a>
<?php } // Show if not last page ?> </td>
<td width="23%" align="center"> <?php if ($pageNum_search < $totalPages_search) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage, $totalPages_search, $queryString_search); ?>">Last</a>
<?php } // Show if not last page ?> </td>
</tr>
</table>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="center"> Records <?php echo ($startRow_search + 1) ?> to <?php echo min($startRow_search + $maxRows_search, $totalRows_search) ?> of <?php echo $totalRows_search ?> </td>
<td> </td>
</tr>
</table>
<p align="center"><br>
</p>
<?php do { ?>
<table width="785" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="158"><font size="2">Church Name/Pastor</font></td>
<td width="203"><font size="2">Address</font></td>
<td width="192"><font size="2">Contact</font></td>
<td width="232"><font size="2">URL</font><font size="2"> </font><font size="2"> </font></td>
</tr>
<tr align="left" valign="top">
<td><font size="2"><?php echo $row_search['churchname']; ?></font></td>
<td><font size="2"><?php echo $row_search['address']; ?> <br>
<?php echo $row_search['city']; ?> <br>
<?php echo $row_search['region']; ?> <br>
<?php echo $row_search['postalcode']; ?> <br>
<?php echo $row_search['country']; ?> </font></td>
<td><font size="2">Phone1:<?php echo $row_search['phone1']; ?><br>
Phone2:<?php echo $row_search['phone2']; ?><br>
Fax:<?php echo $row_search['fax']; ?><br>
Email:<?php echo $row_search['email']; ?> </font></td>
<td><?php echo $row_search['URL']; ?><br>
</td>
</tr>
</table>
<br>
<?php } while ($row_search = mysql_fetch_assoc($search)); ?>
</body>
</html>
<?php
mysql_free_result($search);
?>
if somebody could help me out that would be great thanks for your time....
