id; } $catQuery="select * from category where id='$catid'"; $catResult=mysql_query($catQuery); $catRow=mysql_fetch_object($catResult); $categoryName=$catRow->category ; //echo "
";
//print_r($_SERVER);
/*$catQuery="select * from category where id='$catid'";
$catResult=mysql_query($catQuery);
$catRow=mysql_fetch_object($catResult);
$categoryName=$catRow->category ;*/

if (isset($_GET['search']))
{
	$postWhere="( pro.name like '%".$_GET['search']."%' or pro.name like '".$_GET['search']."%' or pro.name like '%".$_GET['search']."' )";
}
	
if ($postWhere)
	$categoryQuery="select * from product pro where ". $postWhere;
else
	$categoryQuery="select * from product pro where category='$catid'";


$query=$categoryQuery;
$result=mysql_query($query);
$total_records=mysql_num_rows($result);
$page=new Page(); //  to create a new page class object
$page->set_scroll_page(5); // to show 5 individual page links in navigation scrolling
$page->set_total_records($total_records); // to set number of total records 
$records_on_each_page=4; // to show 10 records on each page
$page->set_records_per_page($records_on_each_page); //to set 10 records on each page
$page->show_prev_next=true; //to show previous and next page links (by default true)
//$page->show_scroll_prev_next=true; //shows previous and next page links
$page->show_first_last=true; // to show first and last page links
if(isset($_GET['search']))
	$url="search=".$_GET['search']."&searchtype=".$_GET['searchtype'];
else if(isset($_GET['catid']))
	$url="catid=".$_GET['catid'];
$page->set_qry_string($url); // example for setting the query string
$page->set_page_name("our_products_list.php"); // to set the page name on which paging has to be done
$query=$page->get_limit_query($query); //return the query with limits
$categoryResult=mysql_query($query) or die(mysql_error());
$categoryCount=mysql_num_rows($categoryResult);
?>


Search result for keyword ""
Our Products »
feaid) { $feaQuery="select * from featured where id='$categoryRow->feaid'"; $feaResult=mysql_query($feaQuery) or die(mysql_error()); $feaRow=mysql_fetch_object($feaResult); $feaRow->image=str_replace('.jpg','.png',$feaRow->image); $categoryRow->Ingredients=ucfirst(strtolower($feaRow->ingredients)); $categoryRow->uses=ucfirst(strtolower($feaRow->longDiscription)); $categoryRow->packing=$feaRow->packing; $categoryRow->buynow=$feaRow->pur_link; if (file_exists('FEA_IMAGE/'.$feaRow->image)) { $categoryRow->smallimage='FEA_IMAGE/'.$feaRow->image; } else { $categoryRow->smallimage='images/product1.jpg'; } if (file_exists('FEA_IMAGE/'.$feaRow->image)) { $categoryRow->larimage='FEA_LARGE/'.$feaRow->image; } else { $categoryRow->larimage=''; } } else if ($categoryRow->image=='') { $categoryRow->smallimage='images/product1.jpg'; } else { if (file_exists('PRO_IMAGE/'.$categoryRow->image)) { $categoryRow->smallimage='PRO_IMAGE/'.$categoryRow->image; } else { $categoryRow->smallimage='images/product1.jpg'; } if (file_exists('PRO_LAR_IMAGE/'.$categoryRow->image)) { $categoryRow->larimage='PRO_LAR_IMAGE/'.$categoryRow->image; } else { $categoryRow->larimage=''; } } ?>
larimage) { list($width, $height, $type, $attr) = getimagesize($categoryRow->larimage); ?>
 

name;?>

Active Ingredients

Ingredients;?>

Therapeutic use

uses;?>
Dose : packing;?>
buynow) { ?>
 
total_page>1) { echo $page->get_page_nav(); //displays paging navigation } ?>