On Sep 10, 2012, at 7: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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Maybe right here there needs to be something?
mysqli_stmt_bind_result($stmt, ?????, $_POST['Indx'], ...
in the statement above you have.
mysqli_stmt_bind_param($stmt, 'isisiis', $_POST['Indx'], ...
what ever 'isisiis' is, you need to put somehting in
your ...bind_result() I think.
maybe..
mysqli_stmt_bind_result($stmt, '', $_POST['Indx'],
or
mysqli_stmt_bind_result($stmt, 'isisiis', $_POST['Indx'],
sorry for not a more concrete answer. I am guessing a little. :)
HTH,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
