// Calculate $transportPrice $c = new Criteria(); $c->add(TownsDistancesPeer::TOWN_A, 1); $c->add(TownsDistancesPeer::TOWN_A, 2); $row = TownsDistancesPeer::doSelectOne($c); $transportPrice = $row->getDistance(); this will throw this error: [wrapped: Could not execute query [Native Error: Unknown column 'towns_distances.ID' in 'field list'] [User Info: SELECT towns_distances.TOWN_A, towns_distances.TOWN_B, towns_distances.DISTANCE, towns_distances.ID FROM towns_distances WHERE towns_distances.TOWN_A=2 LIMIT 1]]