Re: Splitting Vars from MySQL in PHP

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