vzwhaley Posted February 23, 2007 Share Posted February 23, 2007 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. PHP Code: $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>"; } } Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 23, 2007 Share Posted February 23, 2007 foreach($CuisineListS AS $c ){ if(in_array($row_Recordset1['ID'], $c)) { echo "Match: " . $row_Recordset1['ID'] . "<br><br>"; } } Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.