$sql = "SELECT `date`, `region`, `magnitude`, Event.lat, Event.long, Event.id, fileName, Sacfile.id
FROM events AS Event
INNER JOIN sacfiles AS Sacfile ON Sacfile.event_id = Event.id
INNER JOIN schools ON Sacfile.school_id = schools.id
WHERE YEAR(date) = ~ajones AND stationCode = 'BINGWEB.BINGHAMTON.EDU'
ORDER BY date DESC;"
$error = "1054: Unknown column 'ajones' in 'where clause'"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 222
Model::query() - CORE/cake/libs/model/model.php, line 2108
SchoolsController::view() - APP/controllers/schools_controller.php, line 55
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 94
Query: SELECT `date`, `region`, `magnitude`, Event.lat, Event.long, Event.id, fileName, Sacfile.id
FROM events AS Event
INNER JOIN sacfiles AS Sacfile ON Sacfile.event_id = Event.id
INNER JOIN schools ON Sacfile.school_id = schools.id
WHERE YEAR(date) = ~ajones AND stationCode = 'BINGWEB.BINGHAMTON.EDU'
ORDER BY date DESC;
Warning (2): array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object [APP/controllers/schools_controller.php, line 69]
$stationCode = "BINGWEB.BINGHAMTON.EDU"
$year = "~ajones"
$cleaner = Sanitize
$curYear = "~ajones"
$getEvents = "SELECT `date`, `region`, `magnitude`, Event.lat, Event.long, Event.id, fileName, Sacfile.id
FROM events AS Event
INNER JOIN sacfiles AS Sacfile ON Sacfile.event_id = Event.id
INNER JOIN schools ON Sacfile.school_id = schools.id
WHERE YEAR(date) = ~ajones AND stationCode = 'BINGWEB.BINGHAMTON.EDU'
ORDER BY date DESC;"
$events = false
$school = false
$age = 1258832213
$teachers = array()
array_key_exists - [internal], line ??
SchoolsController::view() - APP/controllers/schools_controller.php, line 69
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 94
Locations of the origins of the earthquakes that this school recorded.