1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
// On mets le resultat dans une variable pour faciliter l'ecriture de la requete
while ($uneligne=odbc_fetch_array($rq_cpt))
{
$newLigne = $uneligne[0] ;
}
$creation_table = "CREATE TABLE IF NOT EXISTS `parc_option_test` (
`code_groupe` text NOT NULL,
`code_entreprise` text NOT NULL,
`compte_client` text NOT NULL,
`nom_abonne` text NOT NULL,
`utilisateur` text NOT NULL,
`reference` text NOT NULL,
`gsm` text NOT NULL,
`num_sim` text NOT NULL,
`num_sim_jumelle` text NOT NULL,
`num_gsn_carte_jumelle` text NOT NULL,
`num_fax` text NOT NULL,
`num_data` text NOT NULL,
`num_imei` text NOT NULL,
`code_tarif` text NOT NULL,
`code_package` text NOT NULL,
`date_connexion` date NOT NULL,
`date_engagement` date NOT NULL,
`duree_contrat` text NOT NULL,
`$newLigne` text NOT NULL,
`date_deconnexion` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1";
mysql_query($creation_table); |
Partager