On 9/10/2012 8:29 PM, Karl DeSaulniers wrote:

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'],
           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*

*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.

mysqli_stmt_bind_result($stmt, '', $_POST['Indx'],


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

sorry for not a more concrete answer. I am guessing a little. :)

Karl DeSaulniers
Design Drumm

This is almost the exact same problem you posted last week and we were unable to solve it then.

Having said that I think I suddenly see it. An "INSERT" query does not return any 'result', as I believe the intent of the 'bind-result' call is designed for. If you were doing a SELECT to pull those fields from the table this would work I'm guessing. But since it is an INSERT, there are no fields to be bound. That is the error!

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

Reply via email to