Inserting multiple records using a loop

[fkmbate]

Hi,

I am designing a students attendance system which gets the name of the students from mysql database and displays them according to the course selected. Depending on the number of students, a select box with present/absent is displayed along side the name.

 

I would appreciate if someone helps me on how I can use a loop to insert the records all at once

 

[attachment deleted by admin]

[RussellReal]

syntax for a query which will insert MULTIPLE rows would be like:

 

INSERT INTO table (field1,field2,field3) VALUES(a,b,c),(d,e,f),(g,h,i)

 

now.. if you want to do this in a LOOP.. you could try something like this:

$rows = array();

while (whatever) {

  $values = array();

  $values[] = '\'field1ValueforThisResult\'';

  $values[] = '\'field2ValueforThisResult\'';

  $values[] = '\'field3ValueforThisResult\'';

  $rows[] = "(".implode(',',$values).")";

}

mysql_query("INSERT INTO table (field1,field2,field3) VALUES".implode(',',$rows));