when i try to go on my game i get this error

[kaine-]

QUERY ERROR: Unknown column 'h.hChi' in 'on clause'

Query was SELECT u.*,us.*,h.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN houses h ON h.hChi=u.maxChi WHERE u.userid=30

anyone know how to sort it?

[Zero-Affect]

basically it's saying the hChi column isn't available in your houses table so goto your houses table in myphpadmin and have a look it will most likely be hWILL or something like that just simply edit it to hChi.

[kaine-]

ive changed it and it says the same thing :/

[Zero-Affect]

you changed it in the query right not the sql?