Updating multiple fields mysql online dating in faisalabad
I've been working on a script for a few days 50% of it works in terms of installing the data from one table to another.
The part that has me stumped is getting it to update the data.
Find help with installing, configuring, and maintaining your My SQL databases.
Hi, I'm trying to update multiple columns in my db but I keep getting errors with the SQL.
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'; ..
Generally when I visit forums, I just come across crap, but this time I was very surprised, finding a informative forum containing good information. The background behind my script- Pretty much, I just made a login system.
I have multiple fields on admin panel user can add field and delete the fields as well while adding it I placed simple insert query with foreach loop but it is difficult to understand the concept for updating that fields if user deletes a field or updates it is not working if I delete 1 field and update it it deletes 2 or more then 2 fields and when I try to update it is not updating well update issue is due i would be making some mistake with query.
But main thing is about logic which I am unable to build it properly need help.
How to repeat: Install My SQL 4.0.14-standard on Free BSD 4.6 and then either with the command-line client or PHP/Perl DBI send an UPDATE statement which updates more than 1 field in a table. Suggested fix: -Can you provide us with a repeatable test case - table schema (CREATE TABLE statements), minimal current records in the table, the exact UPDATE syntax you're trying to run? No feedback was provided for this bug for over a month, so it is being suspended automatically.
If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
So I know that it has to be returning true, otherwise there'd be an error somewhere or I wouldn't receive the e-mails. Right after the query runs, in PHP, I would make another select query that redumps the row and check the value there. Then all you have to do is find where it's setting it back to the old value.