Multiple Foreach Statements - Help

[AVANI]

I first off want to thank anyone that can assist me with this.

I have 2 arrays from a database that I am trying to display together in a single foreach statement.

Here are the Arrays:

First Array contains the ID's of the Dishes - MySql Table "tmp_orders['dishes']"
Second Array contains the Additional Quantities of each dish - MySql Table "tmp_orders['additional_dishes']"

Both Items are Serialized and Unserialized to get the Array Below:

Array ( [0] => Array ( [0] => Array ( [0] => 18 [1] => 28 [2] => 48 [3] => 39 [4] => 46 [5] => 52 [6] => 71 [7] => 56 ) ) )
Array ( [0] => Array ( [0] => Array ( [0] => 3 [1] => 5 [2] => 3 [3] => 5 [4] => 3 [5] => 5 [6] => 3 [7] => 5 ) ) )

The Objective:

    $dishs=unserialize($cinfo['dishes']);
    $extras=unserialize($cinfo['additional_dishes']);

    $dis = (array($dishs));
    $ext = (array($extras));

   foreach ($dis as $i){
        foreach ($ext as $v){

                $query="SELECT * FROM dishes WHERE id='".$i."'";
                $value=mysql_query($query)or die(mysql_error());		

            while($dishinfo=mysql_fetch_array($value))

            {
    <tr>
        <td class="paymentText2-2"><?php echo $dishinfo['name']; ?></td>	
    <td class="paymentText2">1 + <?php echo $v; ?> </td>
        <?php $ext_total= $v * $dishinfo['price']; ?>
        <td class="paymentText2">SGD <?php echo $ext_total; ?> </td>
    </tr>
                }

    }
 }

The above code only prints array 1 time for each item. The array seems to be to buried and the only way I have even came close to it working was to do 4 foreach statement like below but it causes to many duplicates.

 foreach ($dis as $i){
    foreach($i as $e){
         foreach ($ext as $v){
             foreach ($v as $r){

}}}}

[bradgrafelman]

Before answering your question, let me pose one of my own: Why are the related pieces of data in two separate arrays? That is to say, why didn't you execute a single query that gave you both the ID and the quantity paired together?

[AVANI]

The Reason it was done this way is because it is a 4 step process to the form and I had to store in an alternate location. If you have a better solution I am more than happy to try it.

Thanks

[bradgrafelman]

Not sure I understand what you mean by a "4 step process," but it certainly seems like a "better" (and/or efficient) solution would just be to get all of the relevant data at once and use whatever piece(s) you need as necessary.

Regardless, if you're ensuring that both arrays are the same length, the keys of one correspond to the other, and that the values of the "ID's of the Dishes" are unique, you could always combine the two arrays together using [man]array_combine/man.

EDIT: Even without combining the arrays, you could just use a [man]for/man loop instead with a single counter for both array indeces (since the index into one array would be the same as the corresponding index into the other).

[AVANI]

One last quick thing how to I name the arrays here is how I am inserting them as of right now. I can do what you are saying but I do not know how to pull the values because they are just numbers identically as [0] [1] [2]... etc

                 foreach($dishs as $item) {
		$id[]= $item;

                           foreach($item as $items)

                           { 

			$ides[]=$_POST[$items];

			}

                           $array2 = array($id, $ides);

			$itema=serialize($array2);
		$result = mysql_query("UPDATE tmp_order SET additional_dishes='$itema' WHERE session='".$session_id."'") 
or die(mysql_error());  

header('Location: step4.php');
		}