$select=$db->query("SELECT *, items.name as name from items INNER JOIN estatetype ON estatetype.id=items.estatetype"); $select->execute();