Binding items on Recordset
I want to display or not display based on: if the recordset column has 'Y' or 'N' on the column called 'Include_Questions' (on the actual db) (which on the ecart column is called 'Questions')
I have this starting on line 517 (of the file ecart_questions.php)
if ($eCart1->ConditionalTotal("ID", "eCartCatID", "18")) {
$Recordset3 = new WA_MySQLi_RS("Recordset3",$convacc_cx,1);
$Recordset3->setQuery("SELECT * FROM eCart_products WHERE prod_id = ? AND Cat_ID = '18'");
$Recordset3->bindParam("i", "". $eCart1->DisplayInfo("ID") ."", "-1"); //atc item
$Recordset3->execute();
if ($Recordset3->getColumnVal("Include_Questions") == "Y") {
echo "#fldsetbr { display:block; }";
}
}
I don't know how to successfully make use of bindParam (it only binds the first row of the recordset for me).
To test, add item 19467-88 (on the brakes), (set to include questions)
and item 19467-24 (set Not to include questions)
(first and last items under Brakes).
_______________________________________________________
add a brake item to cart that has include questions set to 'Y' - should show the questions
Then, one set to 'N' - should not show questions for Brakes
Thanks.