Ok houses works and when you click on a house, it shows you the student assigned there.

The relational structure supports one student per house.  This should be fixed.  Basically the students_id should be removed from the houses table, and the students table should have a house_id.  That would make it easy to get it all working right.  I didn't do the students page because the table structures should be updated first.