Re: Re: Problems w/ insert

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

$_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 Ethan,

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!