Array match in while-loop

Question

I am developing a search tool for my project,

My desired output is to get the common value from the different tables. eg) SKR0BP100

How to get this value ??

As i am running the program in for-loop and fetching the values from while-loop, now how to use array_intersect() function? Because for array intersect function, minimum 2 arrays are needed, but i get only one array at a time, as it runs on for-loop. So what should i do ?? Please Help me!

$result = array_intersect($arr1, $arr2);

But i have only one $array (ie, $sid[$i] at a time, as it runs in for-loop.

My program

for($i=0;$i<$cc;$i++)
{

$m1="select * from $u$sc where $b[$i]='$a[$i]' ";
$m2=mysql_query($m1);

echo"$m1<br><br>";

while($we=mysql_fetch_array($m2))
{
$sid[$i]=$we['SI'];

echo"$sid[$i]<br><br>";
}
    }

Desired Output = SKR0BP100

// How to get this??

Present output

select * from Studentsc where Zone='East' 

SKR0BP100
SKR0BP12


select * from Studentsc where Area='Rural' 

SKR0BP129
SKR0BP13
SKR0BP100


select * from Studentsc where Class='12' 

SKR0BP100
SKR0BP101

Answer 1

So if you want to create query then try this

$where = array();
for($i=0;$i<$cc;$i++)
{
    $where[] = $b[$i]."='".$a[$i]."'";
}

$m1="select * from $u$sc where ".implode(" and ",$where); //If you are sure that atleast one value vomes