public static function createStudentFromId($id) { $student = new self(); $query = "SELECT * FROM TUSERS U JOIN TSTUDENTS S ON U.`User ID` = S.`User ID` WHERE U.`User ID` = {$id}"; $user = db_select($query); $student->setUserId($id); $student->setFirstName($user[0]['First Name']); $student->setSurname($user[0]['Surname']); $student->setPrefferedName($user[0]['Preferred Name']); $student->setStudentId($user[0]['Student ID']); $student->setEmail($user[0]['Email']); $student->setRole($user[0]['Role']); $student->setGender($user[0]['Gender']); $student->setDateOfBirth($user[0]['DOB']); $student->setValidation($user[0]['Validation']); return $student; }