Re: Problems w/ insert

From:	Ethan Rosenberg, PhD	Date:	Tue, 11 Sep 2012 00:06:24 +0000
Subject:	Re: Problems w/ insert
References:	1 2 3 4	Groups:	php.db
Request:	Send a blank email to php-db+get-48483@lists.php.net to get a copy of this message

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