how to use two array in single query

[saran12]

How do I use two array in single query?

My code is:

if (isset($_POST['Submit']))
{                
echo $selected_radio = $_POST['q'];
echo $qid=$_POST['qid'];
reset($selected_radio);
reset($qid);
foreach($qid as $qid)
{
    foreach($selected_radio as $selected_radio)
    {
        echo $SQL = "UPDATE answers SET $selected_radio = $selected_radio + 1 WHERE QID=$qid";
        $result=mysql_query($SQL) or die($result."<br/><br/>".$error);
}
}
}
?>

[Dormilich]

hm, yes. two parallel but unsynchronised arrays are really a nuissance.

in case they indeed match, use a standard for() loop. two nested foreach()s can’t do what you want.

PS. I would use Prepared Statements here.
- they prevent SQL injection (which you currently ignore completely)
- they use the not-deprecated MySQLi or PDO libraries
- they’re very efficient when it comes to multiple query execution