';
while($letter=fgets($fop,100))
{
$letter=strtolower($letter);
$letter=trim($letter);
$query1="SELECT ProdGID, ProductName, ProductLink2, ProductLink3 from `wx` WHERE onsale='y' and alivevendor='y' and (productname like '%Blu-ray%' or productname like '%Blu ray%' or productname like '%Bluray%') and ProductName like '$letter%' order by productname ";
$result1=mysqli_query($db, $query1) or die(mysqli_error());
$nrows1=mysqli_num_rows($result1);
if($nrows1!=0)
{
$letter=ucfirst($letter);
$alp=$alp.' '.$letter.'';
$list=$list.' '.$letter.'
';
for ($y=0;$y<$nrows1; $y++)
{
$row=mysqli_fetch_array($result1);
$gpid=$row["ProdGID"];
//----------------------------------------
$pname=stripslashes($row["ProductName"]);
$pname=ucfirst($pname);
$plink=stripslashes($row["ProductLink2"]);
$plink3=stripslashes($row["ProductLink3"]);
$pagelink=$gpid-800000;
if($plink3!='n')
$plink=$plink3.'_'.$pagelink;
//-----------------------------------------
$list=$list.''.$pname.' ';
}
$list=$list.'.......... Top ';
}
}
fclose($fop);//fclose
?>
Blu-ray coupons, discounts and promotional coupon codes
Blu-ray Software
Blu-ray software coupons and promotions by Products
