Warning (512): SQL Error: 1054: Unknown column 'contact_teacher' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 520]

$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) = contact_teacher AND stationCode = 'BCFL'
					 ORDER BY date DESC;"
$error	=	"1054: Unknown column 'contact_teacher' in 'where clause'"
$out	=	null


                //trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL: $sql caused SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 520
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 68
Object::dispatchMethod() - CORE/cake/libs/object.php, line 120
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) = contact_teacher AND stationCode = 'BCFL' ORDER BY date DESC;

IRIS Seismographs in Schools - Station Info

Station Info

Network: IRI

BCFL - Broward College

Location of Broward College .
Icon

Locations of the origins of the earthquakes that this school recorded.

Station Info

Broward College (College)

3501 SW Davie Rd
Fort Lauderdale, FL 33314 USA

This station is a AS-1 seismometer that was installed on 09/30/2009 at an elevation of 4 meters.

www.broward.edu/~jmuza

Latitude: 26.08031
Longitude: -80.23709

Teachers

Jay Muza

Network Information

IRIS (IRI)

This station is a member of the IRIS (IRI) regional network and is represented by the color above.

View All Stations in this Regional Network

Uploaded Data

View earthquakes from other years: 2012 2011 2010 2009 2008 2007 2006 2005

This station has not uploaded any events for this year. Trying clicking one of the other years above.