How can i insert my 2 foreach at the same time ?

[milo_pantig]

Hi There,

Is it Possible to insert on DB my 2 foreach at the same time ? if not help me Please?

e.g of my Codes

foreach($br_id as $br) {
echo $br;
echo "<br>";
}

foreach($mf_location as $mf) {
echo $mf;
echo "<br>";
}

$insert = $DB->query("Insert into movies(br,mf)
values('$br,'$mf')");

Thanks

Mcp

[Weedpacket]

Not really; why not just have a third foreach to do the inserts?

[milo_pantig]

forech () {

foreach($br_id as $br) {
echo $br;
echo "<br>";
}

foreach($mf_location as $mf) {
echo $mf;
echo "<br>";
}

$insert = $DB->query("Insert into movies(br,mf)
values('$br,'$mf')");

}

[hitman6003]

if your two arrays have the same number of items you could do this:

$count = count($br_id);
for($i = 0; $i <= $count; $i++) {
    echo "$br_id[$i]<br>$mf_location[$i]<br>";
    $insert = $DB->query("INSERT INTO movies(br,mf) VALUES ('$br_id[$i]','$mf_location[$i]')");
}