QUICK FIND
//$page = $_REQUEST['page'];
//$van = $_REQUEST['van'];
//$tot = $_REQUEST['tot'];
$item = $_REQUEST['item'];
$ca_id = $cat;
$onhand = $_REQUEST['onhand'];
$active = $_REQUEST['active'];
//if ($_REQUEST['page']==""){$page=1;$van=0;$tot=40;}
// if ($_REQUEST['actie']=="") {$query = "SELECT * FROM products WHERE active='Yes' AND ca_id='27' OR active='Special' AND ca_id='27' ORDER BY item";}
// if ($_REQUEST['actie']=="") {$query = "SELECT * FROM products WHERE ca_id='27' AND ( active='Yes' OR active='Special' ) AND ( ( ba_id = '' OR ba_id = 0 OR ba_id IS NULL ) OR ( ba_id LIKE '%' AND pr_id IN ( SELECT DISTINCT(pr_id) FROM batchproducts )) ) ORDER BY item "; }
//if ($_REQUEST['actie']=="") {$query = "SELECT * FROM products WHERE ca_id='27' AND ( active='Yes' OR active='Special' ) AND ( batch = '' OR batch IS NULL ) ) ORDER BY item ";}
if ( $_REQUEST['actie'] == "" ) { $query = "SELECT * FROM products WHERE ca_id='$ca_id' AND ( active='Yes' OR active='Special' ) AND ( ( ba_id = '' OR ba_id = 0 OR ba_id IS NULL ) OR ( ba_id LIKE '%' AND pr_id IN ( SELECT DISTINCT(pr_id) FROM batchproducts )) ) ORDER BY item "; }
$result= $query;
$result=mysql_query($result);
$result1=mysql_query($query);
$aantal=mysql_num_rows($result1);
if ($aantal>=1) {
echo "
". $aantal. " results - "; $query1 = mysql_query("SELECT * FROM newcategories WHERE ca_id='$ca_id'"); while(list($ca_id, $volgorde, $category, $pagina, $active)=mysql_fetch_array($query1)){ echo $category; } echo "
- ";
$i=1;
$rij = 4;
// while(list($pr_id, $ca_id, $item, $onhand, $price_a, $price_b, $price_c, $price_d, $price_e, $noprice, $title, $description, $thumb, $batch, $active1) = mysql_fetch_row($result)) {
while($product = mysql_fetch_assoc($result)) {
$pr_id = $product['pr_id'];
$ca_id = $product['ca_id'];
$item = $product['item'];
$onhand = $product['onhand'];
$price_a = $product['price_a'];
$price_b = $product['price_b'];
$price_c = $product['price_c'];
$price_d = $product['price_d'];
$price_e = $product['price_e'];
$noprice = $product['noprice'];
$title = $product['title'];
$description = $product['description'];
$optional = $product['optional'];
$thumb = $product['thumb'];
$batch = $product['batch'];
$active1 = $product['active'];
echo "
-
".stripchars($title)."

- more info
";
if ($i == $rij) {
echo "";
$i = 0;
}
$i++;
}
echo "
