INSERT INTO camp_america (codeID, firstname, lastname, dob, sex, email, emailcheck, nationality, residence, tel, address1, address2, address3, address4, town, postcode, county_uk, county_nonuk, request, random, promotion) VALUES ( NULL , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' , '' ) select number from randomnumber order by RAND() limit 1 select distinct country from countries where country != '' order by country asc select distinct county from countries where country = 'United Kingdom' and county != '' order by county asc

	To request a brochure please complete the following details: Personal details: First name: Last name: Date of birth: Select day 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Select month January February March April May June July August September October November December Select year 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 Sex: Male   Female Email: Confirm email: Nationality: Select country United Kingdom ---------- #country.country# Country of Residence: Select country United Kingdom ---------- #country.country# Contact details: Telephone: Address: Town/City: County (UK): Select UK county #county.county# Or county/region (Rest of world): Postcode/zipcode: Please check you have completed all fields correctly