Re: Problems w/ insert

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux