Find value in array

From: Date: Fri, 29 Nov 2002 15:02:21 +0000
Subject: Find value in array
Groups: php.db 
Request: Send a blank email to php-db+get-23735@lists.php.net to get a copy of this message
Hello guys I'm trying to find a value which is into an array inside another array (hope it makes sense). The code: $query = "select cat_code from authorxcat where author_code=$mod_author"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($result); $query_aux = "select * from categories order by cat_name"; $result_aux = mysql_query($query_aux) or die(mysql_error()); while ($row_aux = mysql_fetch_array($result_aux)) { if (in_array($row_aux["cat_code"],$row)) { echo "<tr><td class=\"nolink\">".$row_aux["cat_name"]."</td> <td><input type=\"checkbox\" name=\"".$row_aux["cat_name"]."\" value=\"" .$row_aux["cat_code"]."\" checked></td></tr>"; } else { echo "<tr><td class=\"nolink\">".$row_aux["cat_name"]."</td> <td><input type=\"checkbox\" name=\"".$row_aux["cat_name"]."\" value=\"" .$row_aux["cat_code"]."\"></td></tr>"; } } Well, I'll try to explain it: The first query ($query) is supposed to find some "categories" codes and store them into the $row array. Then I just store all the categories codes into another array called $row_aux. Then I walk through the $row_aux array and check, in every step, if the current code is also into the $row array and according to that the output should be different. The problem is that no matter how many items there are in the $row array, the condition inside the While becomes true just once and not the number of times it should. Hope it is clear enough. Thanks in advanced for your help. ******************************************************* Wilmar Pérez Network Administrator Library System Tel: ++57(4)2105962 University of Antioquia Medellín - Colombia 2002 *******************************************************

« previous php.db (#23735) next »