function get_all( $offset, $max_rec = 10, $orderby = "date_started", $direction = "DESC") { $query = "SELECT f.id, f.date_started, f.manager_id, f.status, u.realname FROM spr_form as f, users as u WHERE u.ID = f.manager_id ORDER BY f.$orderby $direction, f.id DESC LIMIT $offset,$max_rec"; $stmt = $this->dbh->prepare( $query ); $stmt->execute(""); if( $stmt->num_rows() ) { while( $row = $stmt->fetch_array() ) { $data[] = $row; } return $data; } return false; }