Ysurac / FlightAirMap

		}

		//if we didn't find a two chracter prefix lets just search the one with one character

		if ($registration_prefix == "")

		{

			$query  = "SELECT aircraft_registration.registration_prefix FROM aircraft_registration WHERE registration_prefix = :registration_1";

			$sth = $this->db->prepare($query);

			$sth->execute(array(':registration_1' => $registration_1));

			while($row = $sth->fetch(PDO::FETCH_ASSOC))

			{

				$registration_prefix = $row['registration_prefix'];

			}

		}

		//determine which characters are being used and convert the registration code appropiately

		if (strlen($registration_prefix) == 1)

			}

			//if we didn't find a two chracter prefix lets just search the one with one character

			if ($registration_prefix == "")

			{

				$query  = "SELECT aircraft_registration.registration_prefix, aircraft_registration.country FROM aircraft_registration WHERE registration_prefix = :registration_1 LIMIT 1";

				$sth = $this->db->prepare($query);

				$sth->execute(array(':registration_1' => $registration_1));

				while($row = $sth->fetch(PDO::FETCH_ASSOC))

				{

					$registration_prefix = $row['registration_prefix'];

					$country = $row['country'];

				}

			}

		}

		return $country;