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='
';
$nr=0;
while($letter=fgets($fop,100))
{
$letter=strtolower($letter);
$letter=trim($letter);
$query1="SELECT distinct VenGID, vendorName, VendorLink, VendorLink2 from wx WHERE alivevendor='y' and `vupdate`>'2010-01-01' and onsale='y' and `scid`=89 and vendorName like '$letter%' order by vendorName ";
$result1=mysql_query($query1) or die(mysql_error());
$nrows1=mysql_num_rows($result1);
if($nrows1!=0)
{
$nr=$nr+$nrows1;
$letter=ucfirst($letter);
$alp=$alp.' '.$letter.'';
$list=$list.'
'.$letter.'
';
for ($y=0;$y<$nrows1; $y++)
{
$row=mysql_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
?>
Video software discounts and promotions.
|
Video Software Discount Coupons:
Publishers listing |
Pay less with discount codes, coupons, rebates and promotions
|
Video software c oupons and promotions by Publishers:
=$nr?> |
=$alp?> |
=$list?> |
|
require("incl/nav-dvs.php");
?>
|
|
|
require("incl/bot.php");
?>