Problem with foreach looping...

From: Date: Thu, 07 Apr 2005 19:14:34 +0000
Subject: Problem with foreach looping...
Groups: php.db 
Request: Send a blank email to php-db+get-39150@lists.php.net to get a copy of this message
I am attempting to use a simple foreach loop on a query result, and I am only getting the first element of the array back. Here is the code... $exclude_query = "SELECT hostname FROM exclusion"; $exclude_results = mysql_query($exclude_query, $Prod); $exclude = mysql_fetch_array($exclude_results, MYSQL_NUM); foreach ($exclude as $row) { echo "$row\n"; } I don't understand how I am just getting a single item back from this. The query actually returns all 13 entries in the exclusion table. I have tested the query via the mysql client. I also get all 13 elements back if I loop via the following. while ($test = mysql_fetch_array($results, MYSQL_NUM)) { echo "$test[0]\n"; } Is my PHP somehow broke, or am I just missing something here? Thanks. Scott Nipp Phone: (214) 858-1289 E-mail: sn4265@sbc.com Web: http:\\ldsa.sbcld.sbc.com

« previous php.db (#39150) next »