Hello
I have an idea of facilitating the capture cities, like
most of the dating sites,
Either
1
/ he selected the region and result in a second combo offers lists.
I have
already created the first combo for regions in phpMyAdmin
INSERT INTO `sys_pre_values` VALUES ('Region', 'Aq', 1, '__Aquitaine', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Al', 2, '__Alsace', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Au', 3, '__Auvergne', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Ba', 4, '__Basse-Normandie', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Bo', 5, '__Bourgogne', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Br', 6, '__Bretagne', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Ce', 7, '__Centre', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Ch', 8, '__Champagne Ardenne', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Co', 9, '__Corse', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Do', 10, '__DOM/TOM', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Fr', 11, '__Franche Comté', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Il', 12, '__Ile de France', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'La', 13, '__Languedoc Roussillon', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Li', 14, '__Limousin', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Lo', 15, '__Lorraine', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Mi', 16, '__Midi Pyrénées', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'No', 17, '__Nord Pas de Calais', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Ha', 18, '__Haute Normandie', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Pa', 19, '__Pays de la Loire', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Pi', 20, '__Picardie', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Po', 21, '__Poitou Charentes', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Pr', 22, '__Provence Alpes Côte d''azur', '', '', '', '', '');
INSERT INTO `sys_pre_values` VALUES ('Region', 'Rh', 23, '__Rhône Alpes', '', '', '', '', '');
But i can associate the first withe table of city 
or
2 / that the member enters their postcode and it gives him
more than to select the city (maps_ville) ..
field builders===> Enter your Zip Code : 0012012
field builders===> your région (automatic)
field builders===> Choise the city, withe drop box..
I have also prepared the database with the regions, cities,
department like this one:
***********************************************************
***********************************************************
CREATE TABLE IF NOT EXISTS `departement` (
`id_departement` int(11) NOT NULL auto_increment,
`id_region` int(11) NOT NULL,
`code` varchar(3) NOT NULL,
`nom_departement` varchar(250) NOT NULL,
PRIMARY KEY (`id_departement`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;
INSERT INTO `departement` (`id_departement`, `id_region`, `code`, `nom_departement`) VALUES
(1, 22, '01', 'Ain'),
(2, 19, '02', 'Aisne'),
(3, 2, '03', 'Allier'),
(4, 21, '04', 'Alpes de Haute Provence'),
(5, 21, '05', 'Alpes (Hautes)'),
***********************************************************
***********************************************************
CREATE TABLE IF NOT EXISTS `region` (
`id_region` int(11) NOT NULL auto_increment,
`nom_region` varchar(250) NOT NULL,
PRIMARY KEY (`id_region`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
INSERT INTO `region` (`id_region`, `nom_region`) VALUES
(1, 'Aquitaine'),
(2, 'Auvergne'),
(3, 'Bourgogne'),
***********************************************************
***********************************************************
CREATE TABLE IF NOT EXISTS `maps_ville` (
`id_ville` int(11) NOT NULL auto_increment,
`id_departement` int(11) NOT NULL,
`nom` varchar(250) NOT NULL,
`cp` varchar(6) NOT NULL,
`lat` varchar(12) NOT NULL,
`lon` varchar(12) NOT NULL,
PRIMARY KEY (`id_ville`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=34488 ;
INSERT INTO `maps_ville` (`id_ville`, `id_departement`, `nom`, `cp`, `lat`, `lon`) VALUES
(1, 1, 'Amareins', '01090', '46.0803111', '4.7835137'),
(2, 1, 'Ambérieu-en-Bugey', '01500', '45.9577810', '5.3588286'),
(3, 1, 'Ambérieux-en-Dombes', '01330', '45.9974646', '4.9032127'),
(4, 1, 'Ambléon', '01300', '45.7495376', '5.6013809'),
***********************************************************Someone will have an idea for
implementing all
Because
when I try to rename the table "maps_ville" by "sys_zip_codes"
not
working and I feel bad to me
Thank you
