<?php
include 'db.php';
$i=0;
$result15=mysql_query("select c.dishes from c");
while($row=mysql_fetch_array($result15))
{
if($row['dishes']!=NULL)
{
$dish[$i]=$row['dishes'];
$i++;
}
}
//$j=0;
//while($j<$i)
$j=0;
while($j<$i)
{
$result16=mysql_query("select * from dish_box where dish_name='$dish[$j]'");
while($row=mysql_fetch_array($result16))
{
$v_id=$row['dish_id'];
echo $v_id.'<br />';
}
$j++;
}
mysql_close();
?>
This while loop is echoing value only once. Please figure it out why loop is working onlu once?