Problem with foreach looping...
| From: | NIPP, SCOTT V \(SBCSI\) | 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