Re: Re: Problems w/ insert

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