A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 523

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 524

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 526

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 527

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 528

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 529

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/surf_reports.php

Line Number: 531

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') + ABS(w.lon-))*70),1)) AS overall_dist FROM webcam w LEFT JOIN spot s ON' at line 1

SELECT w.name, w.url, s.name AS spot_name, (ROUND(((ABS(w.lat-) + ABS(w.lon-))*70),1)) AS overall_dist FROM webcam w LEFT JOIN spot s ON s.id = w.spot_id WHERE (w.lat >= (-0.15) AND w.lat <= (+0.15) ) AND (w.lon >= (-0.15) AND w.lon <= (+0.15) ) ORDER BY overall_dist LIMIT 3