[SOLVED] Inserting into database using an array

[forumnz]

Hey I have two arrays - one contains names and the other emails.

 

An example might be "Array ([2] => Bob [5] => John) Array ([2] => bob@email.com [5] => john@email.com)

 

What would I do to insert multiple rows with that data so the names and emails go together?

 

Thanks, Sam

[sKunKbad]

You would have to loop through your arrays, and create a database query while doing this looping.

[forumnz]

So you mean do more than 1 query? I would rather do just 1.

 

Is there a way to have something like:

"INSERT INTO table (name, email) VALUES ('$arr_name[1]', '$arr_email[1]'), ('$arr_name[2]', '$arr_email[2]')........ etc

 

Is that possible?

[ngreenwood6]

something like this:

 

for($i = 0; $i < $array_length_goes_here; $i++)
{
$name = $array1[$i];
$email = $array2[$i];

$query = "INSERT INTO table (name,email) VALUES ('$name','$email')";
mysql_query($query);
}