I think that (the title) is the problem I am having. I set up a MySQL connection, I read an XML file, and then I insert those values into a table by looping through the elements. The problem is, instead of inserting only 1 record, sometimes I insert 2 or 3 or 4. It seems to depend on the previous values I have read. I think I am reinitializing the variables, but I guess I am missing something -- hopefully something simple.

Here is my code. I originally had about 20 columns, but I shortened the included version to make it easier to read.

    $ctr = 0;
    $sql =  "insert into csd (id,type,nickname,hostname,username,password) ".
            "values (?,?,?,?,?,?)";
    $cur = $db->prepare($sql);

    for ($ctr = 0; $ctr < $expected_count; $ctr++) {

        list (  $lbl, $type, $nickname, $hostname, $username, $password) = "";
        $bind_vars = array();

        $lbl = "csd_{$ctr}";

        $type      = $ref->itm->csds->$lbl->type;
        $nickname  = $ref->itm->csds->$lbl->nickname;
        $hostname  = $ref->itm->csds->$lbl->hostname;
        $username  = $ref->itm->csds->$lbl->username;
        $password  = $ref->itm->csds->$lbl->password;

        $bind_vars = array($id,$type,$nickname,$hostname,$username,$password);
        $res = $db->execute($cur, $bind_vars);

        # this is a separate function which works, but which only 
        # does SELECTS and cannot be the problem.  I include it because I 
        # want to count the total rows.

        printf ("%d CSDs on that ITEM now.\n",  CountCSDs($id_to_sync));
    }

P.S. I also tagged this SimpleXML because that is how I am reading the file, though that code is not included above. It looks like this:

$Ref = simplexml_load_file($file);