RE: [PHP] Oddity
| From: | Andrew Chase | Date: | Mon, 04 Feb 2002 22:13:08 +0000 |
| Subject: | RE: [PHP] Oddity | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-83475@lists.php.net to get a copy of this message | ||
You can also do
<?
$macroDataArray = mysql_fetch_array($result,MYSQL_ASSOC)
foreach(array_keys($macroDataArray) as $elementkey){
echo "Value for key $elementKey = $macroDataArray[$elementKey]<br>\n";
}
?>
(mysql_fetch_array uses MYSQL_BOTH for the second argument by default, which
returns an array using both numeric and associative keys - that's why you
were getting double results. :))
Per the manual:
---------------------------------------------------------------------
http://www.php.net/manual/en/function.mysql-fetch-array.php
The optional second argument result_type in mysql_fetch_array() is a
constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and
MYSQL_BOTH. This feature was added in PHP 3.0.7. MYSQL_BOTH is the default
for this argument.
By using MYSQL_BOTH, you'll get an array with both associative and number
indices. Using MYSQL_ASSOC, you only get associative indices (as
mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as
mysql_fetch_row() works).
---------------------------------------------------------------------
HTH,
-Andy
> -----Original Message-----
> From: Chris Boget [mailto:chris@wild.net]
>
> > $macroDataArray = mysql_fetch_array( $result );
>
> I'm still curious what is going wrong, but I've found a work arround.
> One of the things I love about PHP is that you learn something new
> just about every day. Instead of fetch_array(), I can use fetch_assoc()
> and it'll do just what I need. :)