Hi all,
I have database of zip code for example,
INSERT INTO pages_zip_code (id, zip, city, st) VALUES
(1, '00501', 'Holtsville', 'NY'),
(2, '00544', 'Holtsville', 'NY'),
(3, '00601', 'Adjuntas', 'PR'),
(4, '00602', 'Aguada', 'PR'),
(5, '00603', 'Aguadilla', 'PR'),
(6, '00604', 'Aguadilla', 'PR'),
(7, '00605', 'Aguadilla', 'PR'),
(8, '00606', 'Maricao', 'PR'),
(9, '00610', 'Anasco', 'PR'),
(10, '00611', 'Angeles', 'PR'),
(11, '00612', 'Arecibo', 'PR'),
(12, '00613', 'Arecibo', 'PR'),
(13, '00614', 'Arecibo', 'PR'),
(14, '00616', 'Bajadero', 'PR'),
(15, '00617', 'Barceloneta', 'PR'),
(16, '00622', 'Boqueron', 'PR'),
(17, '00623', 'Cabo Rojo', 'PR'),
(18, '00624', 'Penuelas', 'PR'),
(19, '00627', 'Camuy', 'PR');
If user enters zipcode, Then state and city column should be auto fill by using database of zip code in django and jQuery .
Please let me know how to do this