[Resolved] Insert multiple data at one time?

[alcibar]

How to insert multiple data in the database for only one submit. OK, I'll make it clearer.
I have a table siblings with fields PrimaryKey, Name and Age. On the ADD page, I have a question there "Do you have siblings?" with a YES and NO checkboxes. Once he check YES, an input form will appear to enter # of siblings. Then after he enter the # of siblings, for example 3, 6 forms will be visible - 3 for the Name field and 3 for the Age field.

Now my question is, can I insert those 3 Names with corresponding Age on the siblings table? As far as I know, you can only insert one data(row) at a time.
NOTE: this is only part of the member registration page. There are many fields he has to fill up.

Please help me on this problem! Ideas, tutorials, samples given are greatly appreciated.

Thanks!

[jayant]

call mysql_query function with the insert query multiple times to insert the data multiple times 😉

or use something like

$sql = "INSERT INTO tablename (fieldname1, fieldname2)
  VALUES
  ('value1-1', 'value1-2'),
  ('value2-1', 'value2-2'),
  ('value3-1', 'value3-2'),
  ('value4-1', 'value4-2'),
  ('value5-1', 'value5-2')";

mysql_query( $sql, $conn );

?>

[alcibar]

I did not know why it works. Great!

[jayant]

now you can also help someone who doesn't know the same 🙂