public function SaveBoatRaces($bo) { $races = $bo['boatraces']; $divisions = $bo['divisions']; $fields = 'raceboatid,raceid,boatid,divisionid,crewmemberid'; $sql = 'START TRANSACTION;'; $sql .= 'DELETE FROM raceboat' . ' WHERE boatid = "' . $bo['boatid'] . '" and raceid in' . ' (select raceid from race where raceseriesid = "' . $bo['raceseriesid'] . '");'; for ($i = 0; $i < count($divisions); $i++) { $d = $divisions[$i]; $sql .= SqlHelper::GetSqlFromRows($fields, $races, 'raceboat', 'divisionid', $d['divisionid'], 'raceboatid'); } $sql .= 'COMMIT;'; //echo $sql; $db = new Database(); $db->ExecuteSQL($sql); return JSONHelper::GetJSON(array(), 'result'); }