Anyone got any ideas?
Code: Select all
<?php
$category = $_POST['category'];
$searchadv = $_POST['searchadv'];
$pricemin = $_POST['pricemin'];
$pricemax = $_POST['pricemax'];
echo "<div class='head'>Advanced Search Results</div>";
$rowsPerPage = 3;
// by default we show first page
$pageNum = 1;
// if $_GET['pagenum'] defined, use it as page number
if(isset($_GET['pagenum']))
{
$pageNum = $_GET['pagenum'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
include "dbconn.php";
$result = mysql_query ("SELECT * FROM products WHERE category = '$category' AND title LIKE '%$searchadv%' AND
(price BETWEEN '$pricemin' AND '$pricemax') LIMIT $offset, $rowsPerPage") or die (mysql_error());
if (mysql_num_rows($result)==0) { echo "<div class='advancedvariable' style='margin-left: 14px; font-weight: normal'>There are no results. Try to be less specific, or increase your price range.</div>"; }
else {
while ($row = mysql_fetch_object($result))
{ echo "
<div class='cat_prodlistbox'>