your answers should be in one table, using an FK to relate them to the questions table.
btw, why did you make up ficticious table names and then add the explanation?
A requirement arises in many systems to update multiple SQL database rows.
For small numbers of rows requiring updates, it can be adequate to use an UPDATE statement for each row that requires an update.
Another big problem i have is how to create a line graph using data from a database such that when the database is altered, the graph automatically updates itself.
if you can offer any help at all, please do so by sending me a mail via ; can you create a directory system using php?
;) table_foobar ( foobar_id, member_id, question_id, answer One, answer Two, answer Three, answer Four ) //Multiple questions for a single foobar Main survey.
But only few tutorial on how to update multiple rows at once. Save the following code as select.php: Note: Due to the size or complexity of this submission, the author has submitted it as a file to shorten your download time. with the pre filled option and some some my provided options Hi, Thanks for the great code. When I fill the SELECT field with table data, I don't know how to pass the selected value to the processing page. But if there are a large number of rows that require an update, then the overhead of issuing large numbers of UPDATE statements can result in the operation as a whole taking a long time to complete.The traditional advice for improving performance for multiple UPDATE statements is to “prepare” the required query once, and then “execute” the prepared query once for each row requiring an update.In this statement, other columns are also updated with respective new values.My SQL UPDATE multiple columns My SQL UPDATE command can be used to update multiple columns by specifying a comma separated list of column_name = new_value.Hi Site Point members I have been perusing through the solutions for "updating multiple rows with one query", but I have a pressing question: How would one "SET" multiple column values with one query?Here is my example..normal update command would be: // question ID ranges from 1-20 // $questionid == 1, $member_id==1 UPDATE table_Foo Bar SET answer One='$ans1Val', answer Two='$ans2Val', answer Three='$ans3Val' WHERE member_id='$memberid' AND question_id='$questionid'; // $questionid == 2, $member_id==1 UPDATE table_Foo Bar SET answer One='$ans1Val', answer Two='$ans2Val', answer Three='$ans3Val' WHERE member_id='$memberid' AND question_id='$questionid'; ..My SQL UPDATE with WHERE My SQL UPDATE command can be used with WHERE clause to filter (against certain conditions) which rows will be updated.The following My SQL statement will update the 'receive_qty' column of newpurchase table with a new value 25 if the value of purch_price is more than 50.To update multiple columns, you use a list comma-separated assignments.You supply the value in each column’s assignment in the form of a literal value, an expression, or a subquery.