in_array problem

[vzwhaley]

I cannot get the following in_array to loop through all of the values of the $CuisineListS array. Does anyone know how to correctly loop through an in_array? In the following code, I should have 5 matches, but it only echoes one match. Any tips will be appreciated.

     $sql = "SELECT * FROM Restaurants WHERE ID = '6'"; 
	$Recordset = mysql_query($sql);
	$RS = mysql_fetch_assoc($Recordset);

$sql1 = "SELECT * FROM RestaurantsCuisine ORDER BY CuisineType ASC";
$Recordset1 = mysql_query($sql1);

$Cuisine = $RS['Cuisine'];
$CuisineListS = explode("|", $Cuisine);

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)) {

if(in_array($row_Recordset1['ID'], $CuisineListS)) {
   echo "Match: " . $row_Recordset1['ID'] . "<br><br>";
   }
}

[bpat1434]

Please do this:

<?php

$sql = "SELECT * FROM Restaurants WHERE ID = '6'"; 
$Recordset = mysql_query($sql); 
$RS = mysql_fetch_assoc($Recordset); 

$sql1 = "SELECT * FROM RestaurantsCuisine ORDER BY CuisineType ASC"; 
$Recordset1 = mysql_query($sql1);

print_r($RS['cuisine']);

while($row = mysql_fetch_array($Recordset1))
  echo $row['ID'];

?>

execute that small script and give us the results.

[vzwhaley]

1 | 2 | 6 | 7 | 8 | 9

1
2
3
23
4
6
7
24
29
25
26
30
8
9
10
11
12
13
14
15
16
17
18
19
20
27
21
22
28

[bpat1434]

It's a possibility that the white-space may be throwing it off. Not likely, but a possibility.

Try this:

$temp = explode('|', $RS['cuisine']);
foreach($temp as $t)
  $CuisineListS[] = trim($t);
$temp = '';

if(in_array(trim($row_Recordset1['ID']), $CuisineListS))
  echo 'Match ('.$row_Recordset1['ID'].')<br />';

[vzwhaley]

Thank you so much, bpat. That works like a charm! I really appreciate your help! Have a wonderful weekend!

[bpat1434]

Not a problem. Don't forget to mark this resolved!!