mysqli_sql_exception Object
(
[message:protected] => Table 'areavi5_2k19.TScore_Test' doesn't exist
[string:Exception:private] =>
[code:protected] => 1146
[file:protected] => /home/areavi5/public_html/_DELETE_scores/new/compare.php
[line:protected] => 46
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/areavi5/public_html/_DELETE_scores/new/compare.php
[line] => 46
[function] => prepare
[class] => mysqli
[type] => ->
[args] => Array
(
[0] =>
SELECT
C.StateAbbr,C.City,
N.Total, O.Total,
N.Amenities, O.Amenities,
N.CostOfLiving, O.CostOfLiving,
N.Crime, O.Crime,
N.Education, O.Education,
N.JobsEconomy, O.JobsEconomy,
N.Housing, O.Housing,
N.Weather, O.Weather
FROM TScore_Test N
JOIN TScore O ON (O.CityID=N.CityID AND O.HoodID IS NULL)
JOIN TCity C ON (C.CityID=N.CityID)
WHERE N.HoodID IS NULL
ORDER BY N.Total
)
)
[1] => Array
(
[file] => /home/areavi5/public_html/_DELETE_scores/new/compare.php
[line] => 221
[function] => fetch
[class] => living_score
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] =>
[sqlstate:protected] => 42S02
)
- il/chicago//
- ny/new york//
- ca/san francisco//
- ca/san diego//
- az/prescott//
- mn/st. paul//