how to add arays in mysql table

[nevsi79]

Hey guys,

 

I've got the following arrays:

Array ( [0] => first name A [1] => first name B [2] => first name C )

Array ( [0] => last name A [1] => last name B [2] => last name C )

Array ( [0] => DOB A [1] => DOB B [2] => DOB C )

 

how can I put them in mySql db table which basically has the following columns:

first name, last name and DOB,

 

I want A (first name A, last name A, DOB A)  to be one entry (row) in my table and

correspondingly (first name B, last name B, DOB B) next entry (row)

and (first name C, last name C, DOB C) another entry (row)

 

Please can anyone help?????

[discomatt]

<?php

$first = array ('matt', 'jim', 'bob');
$last = array ('johnson', 'smith', 'oblaw');
$dob = array ('10/10/10', '15/15/15', '1/2/3');

for ($i = 0; $i < count($first); $i++)
  $qSet[] = '(\'' . $first[$i] . '\', \'' . $last[$i] . '\', \'' . $dob[$i] . '\')';

$q = 'INSERT INTO `table` (`first`, `last`, `dob`) VALUES ' . implode(', ', $qSet);

if (!mysql_query($q) )
  echo 'could not add!<br>' . mysql_error();

?>

[nevsi79]

MAGIC!!!!!! SORTED!

 

You're a life saver! Thank you so much!