Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Accueil / forum / Support / AdsManager Support / Code postal => Ville

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

Notice

The forum is in read only mode.

Code postal => Ville

doblzou
Topic Author
Offline
Bronze

11 years 2 weeks ago #16416 by doblzou

Replied by doblzou on topic Code postal => Ville

Bonjour,

voila mes 3 tables :

CREATE TABLE `regions` (
  `num_region` varchar(2) NOT NULL,
  `nom` varchar(255) NOT NULL,
  PRIMARY KEY (`num_region`)

-- Contenu de la table `regions`

INSERT INTO `regions` (`num_region`, `nom`, `num_dep`) VALUES
('1', 'Alsace'),
('2', 'Aquitaine'),
('3', 'Auvergne'),

table region:

Table département:

CREATE TABLE IF NOT EXISTS `departements` (
  `num_departement` varchar(2) NOT NULL,
  `num_region_dep` varchar(2) NOT NULL,
  `nom` char(32) NOT NULL,
  PRIMARY KEY (`num_departement`),
  KEY `FK_DEPARTEMENT_REGION` (`num_region_dep`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Contenu de la table `departements`

INSERT INTO `departements` (`num_departement`, `num_region_dep`, `nom`) VALUES
('1', '22', 'Ain'),
('2', '20', 'Aisne'),
('3', '3', 'Allier'),

CREATE TABLE IF NOT EXISTS `villes_france_free` (
  `ville_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `num_region_ville` varchar(2) CHARACTER SET latin1 NOT NULL,
  `ville_departement` varchar(3) DEFAULT NULL,
  `ville_nom_simple` varchar(45) DEFAULT NULL,
  `ville_nom_reel` varchar(45) DEFAULT NULL,
  `ville_code_postal` varchar(255) DEFAULT NULL,
  `ville_commune` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`ville_id`),
  KEY `ville_departement` (`ville_departement`),
  KEY `ville_nom_reel` (`ville_nom_reel`),
  KEY `ville_code_postal` (`ville_code_postal`),
  KEY `ville_nom_simple` (`ville_nom_simple`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36831 ;

-- Contenu de la table `villes_france_free`

INSERT INTO `villes_france_free` (`ville_id`, `num_region_ville`, `ville_departement`, `ville_nom_simple`, `ville_nom_reel`, `ville_code_postal`, `ville_commune`) VALUES
(1, '', '01', 'ozan', 'Ozan', '01190', '284'),
(2, '', '01', 'cormoranche sur saone', 'Cormoranche-sur-Saône', '01290', '123'),
(3, '', '01', 'plagne', 'Plagne', '01130', '298'),
(4, '', '01', 'tossiat', 'Tossiat', '01250', '422'),
(5, '', '01', 'pouillat', 'Pouillat', '01250', '309');

Voila j'espere que ca pourra vous aider, je peux aussi vous envoyer les 3 tables en pj au cas ou.

The following user(s) said Thank You: adarr

loic
Offline
Gold

11 years 2 weeks ago #16479 by loic

Replied by loic on topic Code postal => Ville

Ok, je vais regarder ça avant la fin de la semaine.
Merci pour les informations.

Cordialement.

The following user(s) said Thank You: adarr

Time to create page: 0.058 seconds