Load questions into table for answers.
Small hobby website to rate things.
Users "load" a list of questions to answer every time they use a product.
tblProduct
- ProductID (PK)
- Product Name
tblUsers
- UserID
- UserName
- etc...
tblQuestions
- QuestionID (PK)
- Question (string)
tblRatings
- RatingID (PK)
- QuestionID (FK to tblQuestions.QuestionID)
- UserID (FK to tblUsers.UserID)
- ProductID (FK to tblProduct.ProductID)
- Rating (int 1-5)
Order of operations
1 - delete all un-answered questions in tblRatings, WHERE UserID matches
2 - load in new list of questions in tblRatings
Here's what I have so far.
It's only adding one question. I want all questions added.
Any help is much appreciated. It's been a very long time and this is a hobby website. Thanks everyone/anyone! :)
<?php
if ((((isset($_GET["btnRate_x"]))?$_GET["btnRate_x"]:"") != "")) {
$InsertQuery = new WA_MySQLi_Query($db);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "tblRatings";
$InsertQuery->bindColumn("ProductID", "i", "".($RecordsetSearchResults->getColumnVal("ProductID")) ."", "WA_DEFAULT");
$InsertQuery->bindColumn("QuestionID", "i", "".($rsQuestions->getColumnVal("QuestionID")) ."", "WA_DEFAULT");
$InsertQuery->bindColumn("UserID", "i", "".($RecordsetUser->getColumnVal("UserID")) ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "Rate.php";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>