public function executeSaveReturnSourceLocation(sfWebRequest $request) { $pass_id = $this->getRequestParameter('passengerid'); $new_airportname = $this->getRequestParameter('airportname'); $new_airport = AirportPeer::getBySpecificAirportName($new_airportname); $camp_id = $this->getRequestParameter('camp_id'); $camp = CampPeer::retrieveByPK($camp_id); $mission_id = $this->getRequestParameter('mission_id'); $conn = Propel::getConnection(); $sql = 'UPDATE mission_leg set to_airport_id = ' . $new_airport->getId() . ' WHERE mission_id = ' . $mission_id . ' AND from_airport_id = ' . $camp->getAirportId(); $statement = $conn->prepare($sql); $statement->execute(); $sql = 'UPDATE camp_passenger set return_airport_id = ' . $new_airport->getId() . ' WHERE camp_id = ' . $camp_id . ' AND passenger_id = ' . $pass_id . ' AND mission_id = ' . $mission_id; $statement = $conn->prepare($sql); $statement->execute(); $this->airportname = $new_airportname; $this->setTemplate('saveSourceLocation'); }