I'm using the following code to insert a row into mysql database. It inserts the information but inserts three rows instead of one. Maybe I'm just overly tired but i cant seem to figure out why... Can anyone help me out?

PHP Code:

if ($error>0)
    {
    echo "<p>This script has been terminated due to one or more errors. Please read the errors above and try again</p>";
    include "common/end.php";
    die();
    }
    else
    {
    $name2 = htmlspecialchars($name);
    $message2 = htmlspecialchars($message);
    $today=date("U");
    
    $addmessage = "INSERT INTO messages (id, name, date, message) VALUES ('', '$name2', '', '$message2')";
    $addmessage2 = mysql_query($addmessage) or DIE ("Could not add message");
    echo "<p>Message was successfully added to the database. You should be able to see it instantly.</p>";
    } 


Are you getting the message Message was successfully added to the database once or 3 times.

Since you are not entering the values of id & date, you can simplify the query to:

$addmessage = "INSERT INTO messages (name, message) VALUES ('$name2', '$message2')";

I will be adding date soon, and that is true, i dont need id, i will take that out.

The message Message was successfully added to the database only comes up once.

You may echo $addmessage and run its contents in
phpmyadmin.

You may be able to infer the problem from this or
by studying the contents of the two additional rows.

If i echo the SQL and run it in PHPMyAdmin, it only adds one row.

Strangely enough though if i remove id from the script it only adds one row from the script.

My problem is solved and i do not need to re-add id, however I'm curious to know if anyone else knows why that happened?

Field 'id' is more than likely an autonum. If this is the case, you don't need to include it in your query.

You may want to add one additional level of error checking though:

PHP Code:

if ($error>0)
    {
    echo "<p>This script has been terminated due to one or more errors. Please read the errors above and try again</p>";
    include "common/end.php";
    die();
    }
    else
    {
    $name2 = htmlspecialchars($name);
    $message2 = htmlspecialchars($message);
    $today=date("U");
    
    $addmessage = "INSERT INTO messages (name, date, message) VALUES ('$name2', '', '$message2')";
    $insertQuery = mysql_query($addmessage);
    $insertOK = mysql_affected_rows();
    if($insertOK != 1) echo "<p>Query failed; message was not added.</p>";
    else echo "<p>Message was successfully added to the database. You should be able to see it instantly.</p>";
    } 


mysql_affected_rows() will only work if 'id' is autonum and not tinyint.