Dear Sir,
Whenever I am trying to insert data into my database it inserts twice. Please help me.
The code is given below:
THE SQL TABLE:
CREATE TABLE `user` (
`id` int(11) NOT NULL auto_increment,
`iata` int(14) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`companyname` varchar(255) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`city` varchar(255) NOT NULL default '',
`state` varchar(255) NOT NULL default '',
`province` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`phone` int(255) NOT NULL default '0',
`fax` int(255) NOT NULL default '0',
`cemail` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3031 ;
The PHP code:
<?php
$iata = $_POST['iata'];
$name = $_POST['name'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = $_POST['password'];
$companyname = $_POST['companyname'];
$city = $_POST['city'];
$state = $_POST['state'];
$province = $_POST['province'];
$country = $_POST['country'];
$phone = $_POST['phone'];
$fax = $_POST['fax'];
$cemail = $_POST['cemail'];
$query = ("INSERT INTO $SQL_USR_TBL (iata, name, email, username, password, companyname, date, city, state, province, country, phone, fax, cemail) values('$iata', '$name', '$email', '$username', '$password', '$companyname', now(), '$city', '$state','$province', '$country','$phone','$fax','$cemail')");
?>
Please help me Sir.
Thanks
Deepak