17.03.2018, 12:58
Assuming you are using an auto incremented primary key on the House table, why not do
SELECT * FROM `Houses` ORDER BY `HouseID` DESC LIMIT 1
or assuming you are saving a timestamp on the inserted datetime of the house
SELECT * FROM `Houses` ORDER BY `InsertedDateTime` DESC LIMIT 1
SELECT * FROM `Houses` ORDER BY `HouseID` DESC LIMIT 1
or assuming you are saving a timestamp on the inserted datetime of the house
SELECT * FROM `Houses` ORDER BY `InsertedDateTime` DESC LIMIT 1