Updating Multiple Users at Once

timska77

I'm not sure how to even ask what I'm trying to do so if this subject has already been covered then please point me in a good direction. I have a database which stores test scores for users. The instructors can create events where any number of different tests are administered and they enter each users score for each test for ranking. On the page for the event there is a form for each user that the instructor uses to enter the scores for that user. Someone asked me if there is a way to be able to enter scores for multiple users and update them all at once instead of one at a time but I'm not sure how to even approach this problem. Is there a way to do this with javascript and arrays possibly? I've been searching but have not found any info.

Thanks for any ideas.

coldwerturkey

yes you can. but post some relevant code so us not-explainers-but-do'ers can help you out.

timska77

OK, I'm not sure of what coding so I'll try to post a bunch. I'm thinking that the way I made the page originally, with a form for each user, is part of the problem but I'm not good with arrays and it seems like that may be the answer here.

Here is what a users form looks like:

<form id="updatesc1398" name="updatesc1398" method="post" action="event_inst.php" enctype="multipart/form-data" style="display: inline;">
Test 1: <input name="test1" type="text"size="5" value=""/>
Test 2: <input name="test2" type="text" size="5" value="13.40"/>
Test 3: <input name="test3" type="text" id="scorev" size="5" value="6.52"/>
<a href="javascript:document.updatesc1398.submit()" class="accept">GO</a>
<input type="hidden" name="edev" id="edev" value="go">
<input type="hidden" name="updsc" id="updsc" value="go">
<input type="hidden" name="event_id" id="event_id" value="24">
<input type="hidden" name="customers_idx" id="customers_idx" value="98">
</form>

The DB update query is pretty straightforward so no need to look at that and I know how to construct loops pretty well. I know how to combine all of the users into one giant form but not how to POST that info to the page and then create a loop and update the DB. Sorry if I'm too cryptic here I just have no idea to do what I'm trying to do.