After I added a new value I just got this error message: Unknown column 'specificevent' in 'field list'

$query = "INSERT INTO milleniumemails (firstname, lastname, fulladdress, telephone, dateofbirth, email, dateadded, specificevent) VALUES ('$firstname', '$lastname', '$fulladdress', '$telephone', '$dateofbirth', '$email', '$dateadded', '$specificevent')";

Is there a specificevent column in the table? You can't just add a value to the insert query, there has to be a corresponding column in the table as well.

Yes there is that field in the database. All of a sudden it won't add anymore entries to the database.

This is the SQL code for the database I have:

CREATE TABLE IF NOT EXISTS `milleniumemails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`fulladdress` varchar(255) NOT NULL,
`telephone` varchar(255) NOT NULL,
`dateofbirth` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`dateadded` varchar(255) NOT NULL,
`specificevent` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=101 ;

Are you sure the table schema was updated correctly after you added the column? What do you get when you run

describe milleniumemails;

It displays all my columns:

id int(11) NO PRI NULL auto_increment firstname varchar(255) NO NULL lastname varchar(255) NO NULL fulladdress varchar(255) NO NULL telephone varchar(255) NO NULL dateofbirth varchar(255) NO NULL email varchar(255) NO NULL dateadded varchar(255) NO NULL specificevent text NO NULL

I just ran both your create table and insert queries; no error message. Can you post more of your PHP code?

It is weird. It just happened a few days ago when I realized when entries weren't being added to the database. And the thing is I never made any changes.

$link = mysql_connect('localhost', 'username', 'password');
mysql_select_db('database');

$query = "INSERT INTO milleniumemails (firstname, lastname, fulladdress, telephone, dateofbirth, email, dateadded, specificevent) VALUES ('$firstname', '$lastname', '$fulladdress', '$telephone', '$dateofbirth', '$email', '$dateadded', '$specificevent')";

mysql_query($query);

The data comes from a form via POST:

$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zipcode'];
$dateofbirth = $_POST['dateofbirth'];
$telephone = $_POST['telephone'];
$email = $_POST['email'];
$specificevent = $_POST['specificevent'];

I used echo(mysql_error()); to get the error message - Unknown column and its still there for me at least. I wonder if its my host. HostGator.com I'm using.

Try escaping the values beforehand because a single quote could break it.

ex: $specificevent = mysql_real_escape_string($_POST['specificevent']);

Originally Posted by mgraphic

Try escaping the values beforehand because a single quote could break it.

ex: $specificevent = mysql_real_escape_string($_POST['specificevent']);

That made no difference. It has to do with adding the information to the database. I'm getting the values from the POST.

I don't know what then. Maybe do a repair on the table if the table may have gotten corrupted from the file end.