OK, this is me testing your method.
PHP Code:
<?php
require("./global.php");
$shops = $DB_site->query("SELECT * FROM itemshops DESC LIMIT 3");
while ($shop = $DB_site->fetch_array($shops)) {
$i = 1;
$shop_id$i = $shop[shop_id];
$shop_name$i = $shop[shop_name];
$shop_image$i = $shop[shop_image];
$shop_rating$i = $shop[shop_rating];
$shop_profit$i = $shop[shop_profit];
$shop_total$i = $shop[shop_total];
$i++;
}
?>
<html>
<head>
</head>
<body>
$shop_name2</body></html>
But I get an error:
PHP Code:
Parse error: parse error, unexpected T_VARIABLE in /home/virtual/site139/fst/home/staticnetwork/public_html/forum/test.php on line 8


Any ideas? Gurus?