Error: SELECT L.*, SD.*, L.state as short_state, L.siteid as siteid, S.long_name as short1, S2.long_name as short2, SD.airCurrent as airTemp, if(SD.LST_Area > 30, ROUND(SD.LST_Area), '~' ) as waterTemp, LST_AreaUpdated as waterUpdated, SD.windCurrent as windSpeed, SD.airLow as lowTemp, SD.airHigh as highTemp, SD.weatherSummary, G.bounding_box, ROUND(6371 * acos( cos( radians(39.04372) ) * cos( radians( L.lat ) ) * cos( radians( L.lon ) - radians(-77.48749) ) + sin( radians(39.04372) ) * sin( radians( L.lat ) ) ),0 ) as distance FROM `LakeSiteDetail` as L LEFT JOIN loc_state_names S ON S.short_name=L.state LEFT JOIN loc_state_names S2 ON S2.short_name=L.state2 LEFT JOIN lakeSiteData as SD ON L.siteid = SD.siteid LEFT JOIN lake_gis_features G ON G.siteid=SD.siteid WHERE (L.name like '%White's Creek Lake%') AND (state='MS' OR state2='MS') ORDER BY L.name ASC LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Creek Lake%') AND (state='MS' OR state2='MS') ORDE...' at line 43

SELECT L.*, SD.*, L.state as short_state, L.siteid as siteid, S.long_name as short1, S2.long_name as short2, SD.airCurrent as airTemp, if(SD.LST_Area > 30, ROUND(SD.LST_Area), '~' ) as waterTemp, LST_AreaUpdated as waterUpdated, SD.windCurrent as windSpeed, SD.airLow as lowTemp, SD.airHigh as highTemp, SD.weatherSummary, G.bounding_box, ROUND(6371 * acos( cos( radians(39.04372) ) * cos( radians( L.lat ) ) * cos( radians( L.lon ) - radians(-77.48749) ) + sin( radians(39.04372) ) * sin( radians( L.lat ) ) ),0 ) as distance FROM `LakeSiteDetail` as L LEFT JOIN loc_state_names S ON S.short_name=L.state LEFT JOIN loc_state_names S2 ON S2.short_name=L.state2 LEFT JOIN lakeSiteData as SD ON L.siteid = SD.siteid LEFT JOIN lake_gis_features G ON G.siteid=SD.siteid WHERE (L.name like '%White's Creek Lake%') AND (state='MS' OR state2='MS') ORDER BY L.name ASC LIMIT 1
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /home/lakemon/public_html/lakemonster.com/nav_lake.php on line 313

Warning: Cannot modify header information - headers already sent by (output started at /home/lakemon/public_html/lakemonster.com/nav_lake.php:310) in /home/lakemon/public_html/lakemonster.com/nav_lake.php on line 315