foreach loops

[Woodburn2006]

i use the following code to put some values into a DB:

 

foreach($_POST['driver'] as $driver){
		$query = mysql_query("INSERT INTO results (driver) VALUES ('$driver')") or die(mysql_error());
		mysql_query($query, $connection);
		}

 

it works fine for that purpose but i need to add other values from other arrays onto the same rows, is there any way of doing this?

 

this is the page i am working with: http://www.upks.co.uk/admincontrol/index2.php?go=results_add

[DyslexicDog]

mysql  ->  UPDATE

[Woodburn2006]

but then i would need to do each record seperately wouldnt i? which would be more work than needed

[trq]

As an example....

 

<?php

    $a = array(1,2,3);
    $b = array(4,5,6);
    $c = array(7,8,9);

    foreach ($a as $x) {
        $y = current($b);
        $z = current($c);
        echo "INSERT INTO tbl (a,b,c) VALUES ($x,$y,$z)\n";
        next($b);
        next($c);
    }  

?>