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 |
++---
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,
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
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
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
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