[HELP] PHP Auto Increment not working?

[Mitchul]

I'm fairly new to PHP, and made this script last year sometime..

 <?php
 
if($_POST['submit']){
    $date = date("Y-m-d H:i:s");
    $change = $_POST['theUpdate'];
    mysql_query("INSERT INTO `changelog` VALUES ('', '".$change."', '".$date."')") or die(mysql_error());
    $msg = "The change has successfully been added to the changelog.";
 
}
?>

What it does is simply inserts text that you can have as a changelog..
The point is, on XAMPP the code works flawlessly, but when I moved to IIS, the code pretty much shat itself..

When I use the html code to post the change, I get the following error..

Incorrect integer value: '' for column 'id' at row 1

Any help?

 

[Adil]

You're not inserting a value for column one...
You need to insert some sort of value (an int)

 

[Mitchul]

You're not inserting a value for column one...
You need to insert some sort of value (an int)

This is the table..

You must be registered for see links

 

[Adil]

Tick allow null for ID.
See what happens.
(You need to read errors.)

 

[Markshall]

If you set the ID field to Auto Increment in the database, it should automatically do it when a new record is added -- you don't even need the "''" in your code like you have.

You could just do:

mysql_query("INSERT INTO `changelog` VALUES ('".$change."', '".$date."')") or die(mysql_error());

 

[Mitchul]

If you set the ID field to Auto Increment in the database, it should automatically do it when a new record is added -- you don't even need the "''" in your code like you have.

You could just do:

mysql_query("INSERT INTO `changelog` VALUES ('".$change."', '".$date."')") or die(mysql_error());

I used the code above, but now I get this;
Column count doesn't match value count at row 1

 

[Twix]

mysql_query("INSERT INTO `changelog` (`change`, `date`) VALUES ('".$change."', '".$date."')") or die(mysql_error());

Change the change & date to the correct names and it should work.

 

[Mitchul]

Change the change & date to the correct names and it should work.

What do you mean by that? they are the correct names..

 

[Twix]

Where it says (`change`, `date`) - change it to the correct field names!

 

[Mitchul]

 <?php
 
if($_POST['submit']){
    $date = date("Y-m-d H:i:s");
    $change = $_POST['theUpdate'];
    mysql_query("INSERT INTO `changelog` (`date`, `change`) VALUES ('".$change."', '".$date."')") or die(mysql_error());
    $msg = "The change has successfully been added to the changelog.";
 
}
?>

Still the same..

 

[Markshall]

 <?php
 
if($_POST['submit']){
    $date = date("Y-m-d H:i:s");
    $change = $_POST['theUpdate'];
    mysql_query("INSERT INTO `changelog` (`date`, `change`) VALUES ('".$change."', '".$date."')") or die(mysql_error());
    $msg = "The change has successfully been added to the changelog.";
 
}
?>

Still the same..

Why are you attempting to put the change in the date column and the date in the change column?

 

[Mitchul]

Why are you attempting to put the change in the date column and the date in the change column?

I tried it both ways.. both ways didn't work.

 

[Markshall]

Well the code is correct and should definitely work. Double check your database and check the table name is correct and the field names are correct too.