Why won't my code insert records into my MySQL Database?

[cooldood]

<?php
require "db/config.php";
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$country = $_POST['country'];
$state = $_POST['state'];
$city = $_POST['city'];
$zcode = $_POST['zcode'];
$address = $_POST['address'];
$ppemail = $_POST['ppemail'];
$pnumber = $_POST['pnumber'];
$cemail = $_POST['cemail'];
$url = $_POST['url'];
$price = "$5.00";
$query = "INSERT INTO custpackage1000(
id,
FirstName,
LastName,
Country,
State,
City,
ZipCode,
Address,
PayPalEmail,
PhoneNumber,
PrimaryEmail,
WebsiteURL) VALUES (
'1',
'$fname',
'$lname',
'$country',
'$state',
'$city',
'$zcode',
'$ppemail',
'$pnumber',
'$cemail',
'$url')";

mysql_connect($host, $user, $pass) or die("<br /><br /><h1>Fatal error. Please contact support if this persists.</h1>");
mysql_select_db($dbname);
mysql_query($query) or die ("could not open db".mysql_error());
sleep(2);
?>

Why won't the code insert into my database upon submission of data? What am I doing wrong?

[Andy11548]

Is the ID field set to auto?

[cooldood]

Is the ID field set to auto?

Nope, I haven't even set an ID field. Could you please tell me how I would go about doing that? I am not the best at PHP.

Thanks.

[Andy11548]

If you haven't set a id, what is this part of the query all about?

 

$query = "INSERT INTO custpackage1000(
id, // HERE
FirstName,

[cooldood]

If you haven't set a id, what is this part of the query all about?

 

$query = "INSERT INTO custpackage1000(
id, // HERE
FirstName,

 

When I ran the query in PHPMyAdmin, I specified it needed an ID, but I don't know if I did it right. My code that created and configured the tables is as follows:

CREATE TABLE `custpackage1000` (
`id` int(4) NOT NULL auto_increment,
`FirstName` varchar(100) NOT NULL default '',
`LastName` varchar(100) NOT NULL default '',
`Country` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`City` varchar(100) NOT NULL default '',
`ZipCode` varchar(100) NOT NULL default '',
`Address` varchar(100) NOT NULL default '',
`PayPalEmail` varchar(100) NOT NULL default '',
`PhoneNumber` varchar(100) NOT NULL default '',
`PrimaryEmail` varchar(100) NOT NULL default '',
`WebsiteURL` varchar(300) NOT NULL default '',
`OrderStatus` varchar(300) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

CREATE TABLE `custpackage2500` (
`id` int(4) NOT NULL auto_increment,
`FirstName` varchar(100) NOT NULL default '',
`LastName` varchar(100) NOT NULL default '',
`Country` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`City` varchar(100) NOT NULL default '',
`ZipCode` varchar(100) NOT NULL default '',
`Address` varchar(100) NOT NULL default '',
`PayPalEmail` varchar(100) NOT NULL default '',
`PhoneNumber` varchar(100) NOT NULL default '',
`PrimaryEmail` varchar(100) NOT NULL default '',
`WebsiteURL` varchar(300) NOT NULL default '',
`OrderStatus` varchar(300) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

CREATE TABLE `custpackage5000` (
`id` int(4) NOT NULL auto_increment,
`FirstName` varchar(100) NOT NULL default '',
`LastName` varchar(100) NOT NULL default '',
`Country` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`City` varchar(100) NOT NULL default '',
`ZipCode` varchar(100) NOT NULL default '',
`Address` varchar(100) NOT NULL default '',
`PayPalEmail` varchar(100) NOT NULL default '',
`PhoneNumber` varchar(100) NOT NULL default '',
`PrimaryEmail` varchar(100) NOT NULL default '',
`WebsiteURL` varchar(300) NOT NULL default '',
`OrderStatus` varchar(300) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

CREATE TABLE `custpackage10000` (
`id` int(4) NOT NULL auto_increment,
`FirstName` varchar(100) NOT NULL default '',
`LastName` varchar(100) NOT NULL default '',
`Country` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`City` varchar(100) NOT NULL default '',
`ZipCode` varchar(100) NOT NULL default '',
`Address` varchar(100) NOT NULL default '',
`PayPalEmail` varchar(100) NOT NULL default '',
`PhoneNumber` varchar(100) NOT NULL default '',
`PrimaryEmail` varchar(100) NOT NULL default '',
`WebsiteURL` varchar(300) NOT NULL default '',
`OrderStatus` varchar(300) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

CREATE TABLE `custpackage25000` (
`id` int(4) NOT NULL auto_increment,
`FirstName` varchar(100) NOT NULL default '',
`LastName` varchar(100) NOT NULL default '',
`Country` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`City` varchar(100) NOT NULL default '',
`ZipCode` varchar(100) NOT NULL default '',
`Address` varchar(100) NOT NULL default '',
`PayPalEmail` varchar(100) NOT NULL default '',
`PhoneNumber` varchar(100) NOT NULL default '',
`PrimaryEmail` varchar(100) NOT NULL default '',
`WebsiteURL` varchar(300) NOT NULL default '',
`OrderStatus` varchar(300) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

CREATE TABLE `custpackage50000` (
`id` int(4) NOT NULL auto_increment,
`FirstName` varchar(100) NOT NULL default '',
`LastName` varchar(100) NOT NULL default '',
`Country` varchar(100) NOT NULL default '',
`State` varchar(100) NOT NULL default '',
`City` varchar(100) NOT NULL default '',
`ZipCode` varchar(100) NOT NULL default '',
`Address` varchar(100) NOT NULL default '',
`PayPalEmail` varchar(100) NOT NULL default '',
`PhoneNumber` varchar(100) NOT NULL default '',
`PrimaryEmail` varchar(100) NOT NULL default '',
`WebsiteURL` varchar(300) NOT NULL default '',
`OrderStatus` varchar(300) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

 

It's a pretty simple code for now, but I will be adding more features later. Any ideas?

[Tenaciousmug]

$query = "INSERT INTO custpackage1000(
id,
FirstName,
LastName,
Country,
State,
City,
ZipCode,
Address,
PayPalEmail,
PhoneNumber,
PrimaryEmail,
WebsiteURL) VALUES (
'1',
'$fname',
'$lname',
'$country',
'$state',
'$city',
'$zcode',
'$address',
'$ppemail',
'$pnumber',
'$cemail',
'$url')";

 

There. You forgot the address!

Also, do not insert the id manually. thats what the auto increment is for. so delete the id and the $id from the insert statement.

[Andy11548]

In that case, try this:

 

<?php
require "db/config.php";
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$country = $_POST['country'];
$state = $_POST['state'];
$city = $_POST['city'];
$zcode = $_POST['zcode'];
$address = $_POST['address'];
$ppemail = $_POST['ppemail'];
$pnumber = $_POST['pnumber'];
$cemail = $_POST['cemail'];
$url = $_POST['url'];
$price = "$5.00";
$query = "INSERT INTO custpackage1000 VALUES (
'',
'$fname',
'$lname',
'$country',
'$state',
'$city',
'$zcode',
'$address',
'$ppemail',
'$pnumber',
'$cemail',
'$url'
'')";

mysql_connect($host, $user, $pass) or die("<br /><br /><h1>Fatal error. Please contact support if this persists.</h1>");
mysql_select_db($dbname);
mysql_query($query) or die ("could not open db".mysql_error());
sleep(2);
?>

[cooldood]

Thanks so much guys! Your teamwork really did help; it works perfectly now!

Starting to love this community!