Welcome to the $rowshop[name] shop!
$rowshop[description]\n"; echo "\n"; $sql[stock] = "SELECT * FROM `shopstock` WHERE `place` ='$rowshop[type]'"; $res[stock] = mysql_query($sql[stock]) or die(mysql_error()); if(mysql_num_rows($res[stock]) == 0){ echo "
There are no items avaiable at the moment, try again in 10 minutes!"; }else { echo "
\n"; while($rowstock = mysql_fetch_assoc($res[stock])){ //items will be echo'd here } } echo "
"; echo "

"; } } ?>