include "header.php"; if (!(isset($page))) $page=1; $lower=($page-1)*10; /*if (!(isset($catselect))) { ?> exit(0); } */ if (!isset($search) && !isset($select)) $select=true; if ($search){ //exit(0); if ($searchcat=query("select * from categories where name='$searchbyname'")){ $select=true; $catselect=$searchcat[category_id]; } $searchbyname=rtrim($searchbyname, "s, es"); $query="select items.* from items inner join categories using (category_id) where items.name like '%$searchbyname%' or items.description like '%$searchbyname%' or categories.name like '%$searchbyname%'"; //} else { } if ($select){ if ($quickname) { $cat=query("select * from categories where quickname='$quickname'"); $query="select * from items where category_id=$cat[category_id] and active='on' order by name"; $items=mysql_query("select item_id from items where active='on' order by name"); $numitems=mysql_num_rows($items); } else { $cat=query("select * from categories where category_id='$catselect'"); $query="select * from items where active='on' and category_id=$catselect order by name"; $items=mysql_query("select item_id from items where active='on' and category_id=$catselect order by name"); $numitems=mysql_num_rows($items); $catname=query("select name, percent_off from categories where category_id=$catselect"); } } //echo $query; //echo $query; $items=mysql_query($query); if (!(mysql_num_rows($items))) $noitems=true; ?>
|
if ($quickname or $catselect){ ?>
=$cat[description]?> } ?> |
||||||
|
||||||
| We're sorry, there were no items that matched your criteria, please try again. | ||||||
|
=$item[name]?> |
$count++;
}
?>||||||
| //pagination($catselect, $query, $numitems, $page); ?> | ||||||