missing ; before statement
map_data2.php?pos... (line 1)
var lat='54.517927442248'; var lng='-1.532475523414';Invalid query: Unknown column 'Amenities.postcode' in 'where clause'
lat is not defined
with the following code:
Code: Select all
//assign lan and lng values to jscript vars and output them to browser//
$jscript = 'var lat=' . $_GET['lat'] .'; var lng=' . $_GET['lng'] .';';
print $jscript;
error_reporting(E_ALL);// ^ E_NOTICE);
$chkbox_arr = array();
foreach($_GET as $key=>$value) {
if ($value !== '' && $key !=='lat' && $key !=='lng'){
$chkbox_arr[]=' AND Amenities.'.$key."='y'";
}
}Code: Select all
echo xhtmlheader('Create Pub Crawl', 'KEY', 'map_data2.php?' . $_SERVER['QUERY_STRING'], 'mapFunctions.js');i've echoed both $lan and $lng to the browser in create_crawl.php and they show up alright but somehow when i try and echo it in the mapdata script, it interferes with the current code. i tried to get arround this by eliminating the lan and lng vars in the foreach loop but it doesn't seem to have worked.