CODEWITHSUNDEEP
phpmysql
meh
meh

Reputation: 1

MySQL/PHP - inserting an extra row on INSERT statement

I am working on a small PHP + MySQL application. I have run into an issue where one of my insert statements seems to cause MySQL to add an additional somewhat blank row after each insert. Here's my setup:

I have a function that does the insert:

function addFacCertification($facultyID,$month,$year,$completed,$certificatesent,$confirmationtodean,$comments)
    {
        //echo "$facultyID<br>$month<br>$year<br>$completed<br>$certificatesent<br>$confirmationtodean<br>$comments";
        $today = getdate(); 
        $month = $today["mon"];
        $date = $today["mday"];
        $year = $today["year"]; 
        $curdate = "$year" ."-". "$month" . "-" . "$date";
        $sql = mysql_query("INSERT INTO facultycertification (facultyID,cmonth, cyear, completed, certificatesent, confirmationtodean, comments, certifiedon)
                            VALUES ('$facultyID', '$month', '$year', '$completed', '$certificatesent', '$confirmationtodean','$comments', '$curdate')");
        return $sql;
    }

Function call:

$sqlresults = addFacCertification($_POST["facultyID"], $_POST["month"], $_POST["year"], $_POST["completed"], $_POST["csent"],
                                                $_POST["ctodean"], $_POST["comments"]);

Problem is, every time this is run - I get an extra row in my table: (See second row below) Image is here:

http://imgur.com/osiXN

Any ideas why? Here is the table structure:

 id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
    facultyID INT NOT NULL,
    cmonth INT NOT NULL,
    cyear INT NOT NULL,
    completed INT NOT NULL,
    certificatesent INT NOT NULL,
    confirmationtodean INT NOT NULL,
    comments TEXT,
    certifiedon DATE,
    FOREIGN KEY (facultyID) REFERENCES faculty(id)

Upvotes: 0

Views: 1976

Answers (1)

James C
James C

Reputation: 14149

I would imagine that your code is somehow being executed twice. I'd suggest the following (in this order) to debug the issue:

  • Uncomment that echo inside the function and see if it echos out twice (i.e. you're calling the function twice)
  • If you're running this via a web request tail the web server log to see if the request is being made twice
  • Enable general logging or enable profiling on the MySQL server to see what SQL queries are actually run against the server

You could have something like a MySQL trigger on the db doing this if you didn't set it up yourself but I think this is unlikely.

Upvotes: 2

Related Questions