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!



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