require("incl/dbcon.php");
// *****************alphabet**************************
@ $fop=fopen("incl/alphabet.txt","r");//open date file
if (!$fop)
{echo "Error: please reload / refresh page";
exit;}
$alp='';
$list=' ';
while($letter=fgets($fop,100))
{
$letter=strtolower($letter);
$letter=trim($letter);
$query1="SELECT distinct VenGID, vendorName, VendorLink, VendorLink2 from wx WHERE alivevendor='y' and (productname like '%Blu-ray%' or productname like '%Blu ray%' or productname like '%Bluray%') and vendorName like '$letter%' and onsale='y' order by vendorName ";
$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);
//-------------update db to wx-------------------------
$gvid=$row["VenGID"];
$gvid=$gvid-50000;
$vname=stripslashes($row["vendorName"]);
$vname=ucfirst($vname);
$vlink=stripslashes($row["VendorLink"]);
$vlink2=stripslashes($row["VendorLink2"]);
$vendlink=$vlink."_1";
if($vlink2!='n')
$vendlink=$vlink2._.$gvid.'_1';
//----------------end---------------------------
$list=$list.''.$vname.' ';
}
$list=$list.'.......... Top ';
}
}
fclose($fop);//fclose
?>
Blu ray coupon code, discounts and promotions.
Blu ray Software
Blu-ray software coupons and promotions by Publishers: