'; $query1="SELECT distinct scategory, scid FROM `wx` WHERE category='Games' and `vupdate`>'2009-01-01' and onsale='y' order by `scategory`"; $result1=mysql_query($query1) or die(mysql_error()); $nrows1=mysql_num_rows($result1); $categorytable=''; $a=0; for ($y=0;$y<$nrows1; $y++) { $row=mysql_fetch_array($result1); $scat=stripslashes($row["scategory"]); $scid=stripslashes($row["scid"]); if($a!=3) {$a++; $categorytable=$categorytable.' '; } else { $a=1; $categorytable=$categorytable.''; } //$query2="SELECT ProductName, ProductLink2, vendorname from `working` WHERE onsale='y' and alivevendor='y' and `vupdate`>'2009-01-01' and `scat1`='$scatfull' and onsale='y' order by productname "; $query2="select ProdGID, ProductName, ProductLink2, ProductLink3, vendorname from wx WHERE onsale='y' and alivevendor='y' and `vupdate`>'2009-01-01' and scid='$scid' order by productname "; $result2=mysql_query($query2) or die(mysql_error()); $nrows2=mysql_num_rows($result2); $list=$list.'
'.$scat.'

'; for ($i=0;$i<$nrows2; $i++) { $row=mysql_fetch_array($result2); //----------update for wx-------------------- $gpid=$row["ProdGID"]; $pname2=stripslashes($row["ProductName"]); $pname2=ucfirst($pname2); $plink2=stripslashes($row["ProductLink2"]); $plink3=stripslashes($row["ProductLink3"]); $pagelink=$gpid-800000; if($plink3!='n') $plink2=$plink3.'_'.$pagelink; //----------------------------------------- $vname=stripslashes($row["vendorname"]); $vname=ucfirst($vname); $list=$list.''.$pname2.' ........ ( '.$vname.' )
'; } $list=$list.'..........
Top
'; } $categorytable=$categorytable.'

'; ?> Games categories and promotional coupons.

Games Categories

discount codes, coupons, rebates and promotions