Homoeoheal
9479760518

HOMOEOHEAL.COM

query($selDis); $sn="1"; echo "
"; while($disRow=$disResult->fetch_assoc()) { $getimg=$disRow['img']; $count=strlen($disRow['link']); if($count > 0) {$link = "href='".$disRow['link']."' target='_blank'";} else{$link="href='#'";} echo "
"; } echo "
"; ?>

Deal of the Day

"; $result=$conn->query($ShowProduct); $c=mysqli_num_rows($result); if($c==0) { echo ""; } while($row=$result->fetch_assoc()) { $product_id="".$row['ProdID'].""; $id=$row['ProdID']; $showdesp="select DescriptionHead,Description from productdescription where ProdID=$id"; $ex=$conn->query($showdesp); $pid=$row['PackageID']; $showPack="select package, unit from packaging where pid=$pid"; $sp=$conn->query($showPack); $price="".$row['cost'].""; $dis="".$row['Discount_amt'].""; //$currPrice=round($price - ($price * $dis / 100),0); $currPrice="".$row['netAmt'].""; $a++; echo "
"; //if($row['Discount_amt']) if($row['offertype'] == "dip") { echo"

".$row['Discount_amt']."%

Off

"; } if($row['offertype'] == "qty") { echo "
Buy ".$row['buying_qty']." Get ".$row['offerqty']." Free
"; } if($row['offertype'] == "volDiscount") { echo "
Buy ".$row['buying_qty']." Get ".$row['offerqty']." % Off
"; } echo "

Available Options

"; echo"

".$row['Product']."

".str_replace('%26','&',$row['Brief'])."

Available in

"; while($pack=$sp->fetch_assoc()) { echo "".$pack['package']. " : Rs. ".$resultCost['cost']." /-"; } echo "
"; while($des=$ex->fetch_assoc()) { $data = "

".$des['DescriptionHead']." : ".$des['Description']."

"; echo $data; } echo "
".str_replace('%26','&',$row['Brief'])."
".$row['cost']." ".$row['buying_qty']." Pcs @ $currPrice
"; if($a%6==0) { echo "
"; echo "
"; } } ?>

Featured Products

0"; $ShowProduct=" select *,prodID,(select cost from productsizecost where prodid=p.prodID limit 1) cost from product p where isdel=0 and FeatureProduct=1 "; // $ShowProduct="select *,p.prodID, cost from product p,productsizecost pc where p.prodid=pc.prodid and p.isdel=0 and FeatureProduct=1"; $result=$conn->query($ShowProduct); $a=0; echo "
"; while($row=$result->fetch_assoc()) { $a++; $product_id="".$row['prodID'].""; $id=$row['prodID']; $showdesp="select DescriptionHead,Description from productdescription where ProdID=$id"; $ex=$conn->query($showdesp); $pid=$row['PackageID']; $showPack="select package, unit from packaging where pid=$pid"; $sp=$conn->query($showPack); //____GET Cost $getCost="select PSCID, ProdID, Size, Unit, Cost from productsizecost where ProdID=$product_id and isdel=0"; $resultCost=$conn->query($getCost); echo "

Available Options

"; /* mysqli_data_seek($resultCost, 0); while($rowresultCost=$resultCost->fetch_assoc()) { echo " "; }*/ echo"

".$row['Product']."

".str_replace('%26','&',$row['Brief'])."

Available in

"; while($pack=$sp->fetch_assoc()) { echo "".$pack['package']. " : Rs. ".$resultCost['cost']." /-"; } echo "
"; while($des=$ex->fetch_assoc()) { $data = "

".$des['DescriptionHead']." : ".$des['Description']."

"; echo $data; } echo "
".str_replace('%26','&',$row['Brief'])."
"; if($a%6==0) { echo "
"; echo "
"; } } echo "
"; ?>

Find Your Medicine

query($selFindMedi); while($rowFindMedi=$resultFindMedi->fetch_assoc()) { echo " "; } ?>