I have created a table "cp_autocomplete"
And i have inserted manually all the french postal codes.
The table is like that :
Code:
CREATE TABLE IF NOT EXISTS `cp_autocomplete` (
`CODEPAYS` char(2) NOT NULL,
`CP` varchar(10) NOT NULL,
`VILLE` varchar(180) NOT NULL,
`NOMADMIN1` varchar(100) NOT NULL,
`CODEADMIN1` varchar(20) NOT NULL,
`NOMADMIN2` varchar(100) NOT NULL,
`CODEADMIN2` varchar(20) NOT NULL,
`NOMADMIN3` varchar(100) NOT NULL,
`CODEADMIN3` varchar(20) NOT NULL,
`LATITUDE` double NOT NULL,
`LONGITUDE` double NOT NULL,
`ACURANCY` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Now with AutoAction plugin how procede to compare the postal code in database in this table if i create a postal code field ? or maybe i could put the "VILLE" corresponding to the user choice from the fiel cb_cp in another field cb_ville ?
krileon
