Jump to content

How can I enter multiple values into mysql at the same time?

- - - - -

  • Please log in to reply
2 replies to this topic

#1
NumOne

NumOne

    Newbie

  • Members
  • Pip
  • 9 posts
Hi

I'm designing a web site for instructors and students to enter and show the marks. The problem that I'm facing is if the instructor wants to enter the students' marks, he gets a page like this:

Posted Image

As you can see, The IDs are already shown and the instructor must insert the rest of the marks. The problem is when the instructor press submit button, the marks must be inserted into the database. The question is what is the statement that takes the marks and inserts them into the database?

I hope now it is clear. Thanks

#2
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
SQL INSERT INTO Statement
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
Alexander

Alexander

    It's Science!

  • Moderators
  • 4,124 posts
  • Location:Vancouver, Eh! Cleverness: 200
Also, HTML forms can allow names as arrays, for example the name for the score1 box can be score1[], and it will maintain an array in to $_POST['score1'][...]
Be sure to read the updated FAQ! || Health is achieved through the same 10,000 steps.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users