"; //mysql_connect("localhost", "username", "password") or die(mysql_error()); // online version, not the actual one //mysql_select_db("database") or die(mysql_error()); // online version, not the actual one mysql_connect("localhost", "aj", "aj1") or die(mysql_error()); // local version, as used for testing mysql_select_db("FloridaMap") or die(mysql_error()); // local version, as used for testing $result = mysql_query("SELECT placelist.*, iconimage.subGroup, iconimage.fileName, iconimage.hoverDescription, iconimage.addChar, iconimage.vAdd, iconimage.aAdd, iconimage.addColour, iconsize.iWide, iconsize.iHigh, iconsize.vRef, iconsize.aRef, iconsubgroup.mainGroup, iconsubgroup.subDescription, iconmaingroup.mainDescription FROM (((placelist LEFT JOIN iconimage ON placelist.placeType=iconimage.placeType) LEFT JOIN iconsize ON iconimage.fileName=iconsize.fileName) LEFT JOIN iconsubgroup ON iconimage.subGroup=iconsubgroup.subGroup) LEFT JOIN iconmaingroup ON iconsubgroup.mainGroup=iconmaingroup.mainGroup "); echo ""; while($row = mysql_fetch_array($result)) { echo""; echo"" . $row['placeID'] . ""; echo"" . $row['placeType'] . ""; echo"" . $row['ewSquare'] . ""; echo"" . $row['nsSquare'] . ""; echo"" . $row['inOver'] . ""; echo"" . $row['inDown'] . ""; echo"" . $row['iWide'] . ""; echo"" . $row['iHigh'] . ""; echo"" . $row['aRef'] . ""; echo"" . $row['vRef'] . ""; echo"" . $row['addChar'] . ""; echo"" . $row['addColour'] . ""; echo"" . $row['aAdd'] . ""; echo"" . $row['vAdd'] . ""; echo"" . $row['fileName'] . ""; echo"" . $row['hoverDescription'] . ""; echo"" . $row['subGroup'] . ""; echo"" . $row['subDescription'] . ""; echo"" . $row['mainGroup'] . ""; echo"" . $row['mainDescription'] . ""; echo"" . $row['itemHover'] . ""; echo""; } echo ""; ?>