Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-28 Thread Matt Pelmear
$stmt = mysqli_stmt_prepare( $cxn, $sql12 );// line 507 //Warning: mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, object given in /var/www/x5.php on line 507 $cxn is not a mysqli_stmt. Are you perhaps passing the mysqli database resource instead of the statement? See this

Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Matt Pelmear
Ethan, Please accept my apologies for the minor errors in the untested code I previously provided for your edification. Consider the following tested code: CREATE TABLE test (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, data INT UNSIGNED); INSERT INTO test (data) VALUES (123),(124),(1

[PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Ethan Rosenberg, PhD
Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order mysq

[PHP-DB] Prepared Statements - Select - Bind Parameters

2012-09-27 Thread Ethan Rosenberg, PhD
Dear list - Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order mysqli_stmt_bind_param($stmt, "num", $a, $b, $