: navigation_list($category_id); ?>
$search_lbl
"; $list = "SELECT * FROM product, product_category_xref, category WHERE "; $count = "SELECT count(*) as num_rows FROM product, product_category_xref, category WHERE "; $q = "(product.product_name LIKE '%$keyword%' OR "; $q .= "product.product_sku LIKE '%$keyword%' OR "; $q .= "product.product_s_desc LIKE '%$keyword%' OR "; $q .= "category.category_name LIKE '%$keyword%' OR "; $q .= "product.product_desc LIKE '%$keyword%'"; $q .= ") "; $q .= "AND product.product_parent_id='' "; $q .= "AND product.product_id=product_category_xref.product_id "; $q .= "AND category.category_id=product_category_xref.category_id "; $q .= "AND product.product_publish='Y' "; $q .= "ORDER BY category.category_name ASC"; $list .= $q . " LIMIT $offset, " . SEARCH_ROWS; $count .= $q; } else { echo "$browse_lbl
"; $list = "SELECT * FROM product, product_category_xref, category WHERE "; $count = "SELECT count(*) as num_rows FROM product, product_category_xref, category WHERE "; $q = "product_parent_id=''"; $q .= "AND product.product_id=product_category_xref.product_id "; $q .= "AND category.category_id=product_category_xref.category_id "; $q .= "AND product.product_publish='Y' "; $q .= "ORDER BY category.category_name ASC"; $list .= $q . " LIMIT $offset, " . SEARCH_ROWS; $count .= $q; } $db->query($count); $db->next_record(); $num_rows = $db->f("num_rows"); if ($num_rows == 0) { echo "
Your search returned 0 results."; } else { ?>
query($list); while ($db->next_record()) { $hlwView = 0; $flypage = $ps_product->get_flypage($db->f("product_id")); if ($hlwRow==0 and $hlwView==0){ ?> get_flypage($db->f("product_id")); ?> "; ?>
purl(URL . "?page=$flypage&product_id=" . $db->f("product_id") . "&category_id=" . $db->f("category_id")); ?> >Item p("product_sku"); ?>
p("product_name"); ?>
get_price($db->f("product_id")); echo $db->f("$product_id"); if ($price) { echo "$" . $price["product_price"] . " USD"; } else { echo ("Contact for pricing."); } ?>
f("product_id") . "&category_id=" . $db->f("category_id")); ?>"> show_image($db->f("product_thumb_image"),"height=100 width=100 align=right"); ?>
f("product_id");?>> hidden_session() ?>
   
purl(URL . "?page=$flypage&product_id=" . $db->f("product_id") . "&category_id=" . $db->f("category_id")); ?> >Item p("product_sku"); ?>
p("product_name"); ?>
get_price($db->f("product_id")); echo $db->f("$product_id"); if ($price) { echo "$" . $price["product_price"] . " USD"; } else { echo ("Contact for pricing."); } ?>
f("product_id") . "&category_id=" . $db->f("category_id")); ?>"> show_image($db->f("product_thumb_image"),"height=100 width=100 align=left"); ?>
f("product_id");?>> hidden_session() ?>

 

 
Pages: = SEARCH_ROWS) { $prevoffset=$offset-SEARCH_ROWS; echo " Previous "; } // Get total pages $num_pages = intval($num_rows / SEARCH_ROWS); if ($num_rows % SEARCH_ROWS) { $num_pages++; } if ($num_pages != 1) for ($i=1;$i<=$num_pages;$i++) { if (($offset < $i*SEARCH_ROWS) && ($offset >= ($i-1)*SEARCH_ROWS)) { $pagenumber = "$i"; } else $pagenumber = $i; $newoffset = SEARCH_ROWS * ($i-1); echo "$pagenumber "; } if (($offset+SEARCH_ROWS < $num_rows) && $num_pages != 1) { $newoffset = $offset + SEARCH_ROWS; echo "Next \n"; } ?>