Dear List -
I am trying to use prepared statements with the following code:
$allowed_fields = array
('Cust_Num' => 'i', 'Fname' => 's', 'Lname' =>
's', 'Street' => 's','City'=> 's', 'State' => 's', 'Zip' => 'i',
'Phone' => 'i', 'Note
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
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
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 -
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 |
++---