Re: Problems w/ insert

On 9/10/2012 8: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
Ethan - PS to my other response:  I think you should make a change to 
use the preferred syntax for the execute statement.  The one you are 
using is deprecated, so will be removed in the future.  May as well 
write code that isn't already on the way out.

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