Posted by Richard Lynch on 05/01/05 04:41

On Fri, April 29, 2005 4:36 pm, Philip Olson said:
>> > I remember in Perl I used to extract vars from a single fetchrow by
>> adding
>> > each var name to the beginning (like this). Only this ain'ta workin
>> :)...
>> > Anyone know the right syntax to do this?
>> >
>> > ($var1, $var2, $var3)= mysql_fetch_array($result, MYSQL_ASSOC)
>>
>>
>> list($var1, $var2, $var3) = mysql_fetch_array($result, MYSQL_ASSOC);
>> http://us4.php.net/manual/en/function.list.php
>
> But remember that list() only works with numerical
> arrays so use MYSQL_NUM (or array_values()) in the
> above. For associative, extract() can be useful.

I dunno what the documentation is trying to say when it says "list only
works with numerical indices" but it's patently false:

php -a
<?php
$foo = array('a'=>'apple', 'b'=>'banana', 'c'=>'coconut');
while (list($k, $v) = each($foo)){
echo "$k: $v\n";
}
?>
Content-type: text/html
X-Powered-By: PHP/4.3.11

a: apple
b: banana
c: coconut

It has worked just fine with alpha indices since PHP 3.0rc2, at a minimum,
cuz I've been doing it that long.

I dunno who was smoking what that day they typed the documentation :-)

I'm pretty sure it's not an "undocumented feature" that it works.

--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]