Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -1 down vote favorite

I have a table called result in mySQL. I want to insert a multiple rows one single click. Basically teacher is putting student result in to data base through php:

table: result

entity: result, student_id

share|improve this question
1  
Please add the snippet of your insert statement. No more than 5-7 lines please. –  Itay Moav -Malimovka Jun 10 '12 at 15:08
 
Moav has showed you the correct syntax (or you could use a foreach loop if you're not going to be inserting very many rows)... but please try to be clearer when asking your question. Your use of the term "single click" is very unhelpful as you seem to be discussing PHP and MySQL, neither of which register "clicks" –  Ben D Jun 10 '12 at 15:10
add comment

1 Answer

up vote 4 down vote

Your php script will need to construct the insert sql in the following manner (I assume your table T1 has two fields F1 and F2, and the input is v11 v12 v21 v22 etc)

INSERT INTO T1 (F1,F2)
VALUES
(V11,V12),
(V21,V22),
...
...
(Vn1,Vn2);
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.