our PS2 accessories:
$username="orknpn6_xettmu_2"; $password="x2DYW4rltBqw#j9f"; $database="orknpn6_xettmu_2"; ?> mysql_connect("localhost",$username,$password) or die(mysql_error()); mysql_select_db($database); ?> $query="SELECT * FROM products WHERE Platform='PS2' ORDER BY STOCK DESC, SKU DESC"; ?> $result=mysql_query($query); $num=mysql_num_rows($result); ?> $result = mysql_query($query); print mysql_error(); mysql_close(); ?> $id=mysql_result($result,$i,"id"); $sku=mysql_result($result,$i,"sku"); $platform=mysql_result($result,$i,"platform"); $name=mysql_result($result,$i,"name"); $price=mysql_result($result,$i,"price"); $stock=mysql_result($result,$i,"stock"); $clink=mysql_result($result,$i,"clink"); $dlink=mysql_result($result,$i,"dlink"); $ilink=mysql_result($result,$i,"ilink"); $ilinkalt=mysql_result($result,$i,"ilinkalt"); $description=mysql_result($result,$i,"description"); echo"
| ";
$i++;
?>
if ( $objResult["stock"]==0 ) { echo "£$objResult[price], but out of stock "; } else { echo << | ";
if(($i)%2==0)
{
echo"
(click to go back to top)
