php mysql_fetch_array() not working as expected

$result = mysql_query($strSql);
foreach($bestmatch_array as $restaurant)
        {   
            while($row = mysql_fetch_array($result))
            {   
                if($restaurant == $row[0])
                {
                    $value = $row[1];
                }
            }
        }

What I am trying to do is sort the result of array formed by query according to the values stored in $bestmatch array.

I don't know what I am doing wrong but the 4th line just seems to run once. Please help guys. Thanx in advance.

Answer:

php mysql_fetch_array() not working as expected

Your expectation is not right.

foreach($bestmatch_array as $restaurant)
        {   
            // This loop will only run for first iteration of your foreach.
            while($row = mysql_fetch_array($result))
            {

            }
            // everything has been fetched by now.
        }

That is a logically incorrect sequence.

You expect your inner loop to be called over and over again as many times as you have the outer loop run but record fetch does not work like that. For outer loop's first run all the rows in $result will be fetched and since you do not reset the counter after your while loop that means after the first run there will be no more rows for the next run.

Solution? Fetch the row from mysql first then use a simple in_array call to check whether that restaurant is there in your array.

$result = mysql_query($strSql);
while($row = mysql_fetch_array($result))
{   
     $name=$row[0];
     if(in_array($name,$bestmatch_array))
        $value=$name;
}

Answer:

Store the results of the query in the array first:

$result = mysql_query($strSql);
$results_row = array();
while($row = mysql_fetch_array($result))
        {   
            $results_row[] = array($row[0],$row[1]);
        }

foreach($bestmatch_array as $restaurant)
    {   
        foreach ($results_row as $key => $value) 
          {
            if($restaurant == $results_row[$key][0])
            {
                $value = $results_row[$key][1];
            }
        }
    }