Re: [PHP-DB] Re: Problems w/ insert -- SOLVED!!!

2012-09-13 Thread Jim Giner
On 9/13/2012 9:15 PM, Ethan Rosenberg, PhD wrote: Dear list - Thanks to all. It now works! The problem, as you correctly noted, was the erroneous inclusion of the bind-results statement. Removed that and it worked!! Thanks again! Ethan Methinks Ethan is thanking the group for assistance o

Re: [PHP-DB] Re: Problems w/ insert -- SOLVED!!!

2012-09-13 Thread Ethan Rosenberg, PhD
Dear list - Thanks to all. It now works! The problem, as you correctly noted, was the erroneous inclusion of the bind-results statement. Removed that and it worked!! Thanks again! Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

Re: [PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Jim Giner
On 9/11/2012 12:04 AM, Matt Pelmear wrote: Ethan, I am curious why you are using mysqli_stmt_bind_result() on a statement that is an INSERT query? I don't use mysqli, but as I read the documentation it seems to me that this method is intended to bind results from a SELECT query into variables so

Re: [PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Jim Giner
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);

Re: [PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Matt Pelmear
Ethan, I am curious why you are using mysqli_stmt_bind_result() on a statement that is an INSERT query? I don't use mysqli, but as I read the documentation it seems to me that this method is intended to bind results from a SELECT query into variables so that you can simply call mysqli_stmt_fe

Re: [PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Karl DeSaulniers
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 = "INSE