Re: Problems w/ insert

On 9/10/2012 8:06 PM, Ethan Rosenberg, PhD wrote:

Dear list - Here is my code: $sql3 = "select max(Indx) from Visit3";

             $result7 = mysqli_query($cxn, $sql3);
             $row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);

             $Indx = $row7[0];
             $sql2 =  "INSERT INTO Visit3(Indx, Site, MedRec, Notes,

Weight, BMI, Date) VALUES(?, ?, ?, ?, ?, ?, ? )";

             mysqli_stmt_prepare( $stmt, $sql2 );

             $_POST['Indx'] = $Indx;

             $_POST['Date'] = $Date;

             mysqli_stmt_bind_param($stmt, 'isisiis', $_POST['Indx'],

$_POST['Site'], $_POST['MedRec'],

                 $_POST['Notes'], $_POST['Weight'], $_POST['BMI'],

$_POST['Date']);

             mysqli_execute($stmt);
             mysqli_stmt_bind_result($stmt, $_POST['Indx'],

$_POST['Site'], $_POST['MedRec'], $_POST['Notes'],

                 $_POST['Weight'], $_POST['BMI'], $_POST['Date']);

*//The error is in this statement*

            mysqli_stmt_fetch($stmt);
            mysqli_stmt_close($stmt);

*Warning: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement* * * Help and advice, please. Ethan Rosenberg Ethan - PS to my other response: I think you should make a change to use the preferred syntax for the execute statement. The one you are using is deprecated, so will be removed in the future. May as well write code that isn't already on the way out.