Re: [PHP-DB] Prepared Statements - Search

2012-09-13 Thread Karl DeSaulniers
Ethan, 9 times out of 10 your answer is in the error statement. Warning: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement. GL, Best, Karl On Sep 13, 2012, at 7:09 PM, Ethan Rosenberg, PhD wrote: Dear List - Here is another problem

[PHP-DB] Prepared Statements - Search -- SOLVED!!!

2012-09-13 Thread Ethan Rosenberg, PhD
Dear List - -->> THANKS TO ALL. See below <-- Here is another problem I am having with prepared statements. The last one was INSERT, this one is SELECT. Here is the database: mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Ke

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] Prepared Statements - Search

2012-09-13 Thread Fjalar Sigurðarson
Does the list of the SELECT fields not have to match the variables you are binding? E.g. if you do not include MedRec in your SELECT then you have no MedRec data to bind from your $sql11 variable to the $MedRec varable and then nothing to print there... or what? Am I just fabulating? :). Cheers,

[PHP-DB] Prepared Statements - Search

2012-09-13 Thread Ethan Rosenberg, PhD
Dear List - Here is another problem I am having with prepared statements. The last one was INSERT, this one is SELECT. Here is the database: mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++---