';
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 `scid`=104 and ProductName like '$letter%' order by productname ";
//$result1=mysql_query($query1) or die(mysql_error());
//$nrows1=mysql_num_rows($result1);
$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 for wx -------------
$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;
//----------------end-----------------
$list=$list.''.$pname.' ';
}
$list=$list.'.......... Top ';
}
}
fclose($fop);//fclose
?>
Files and disk Backup tools discounts and promotional coupons
Files and disk Backup tools: products listing
Pay less for files and disk Backup tools with discount codes, coupons, rebates and promotions
