Re: Assign multiple variables from mysql_fetch_row() call

From: Date: Tue, 04 Sep 2001 21:29:42 +0000
Subject: Re: Assign multiple variables from mysql_fetch_row() call
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-65952@lists.php.net to get a copy of this message
> In perl I can say something like: > > ($var1, $var2) = $sqh->fetchrow_array() > > > to assign column values to more than one variable at a time. So I > tried similar syntax with PHP: > > > ($var1, $var2) = mysql_fetch_row($sqh); > > > but could not seem to work it out. > > I know you can do this with a temporary array, and then take values > out of the array. But it would be nice to omit the temporary array. > > Is it possible? ($var1, $var2) is magic. I hate magic. What do you look up in the Perl manual when you hit syntax like that? In PHP the equivalent syntax is: list($var1, $var2) = ... It does exactly the same thing, and it is legible. Anybody can pop over to http://php.net/list and get an explanation of what the code does if they run across it. -Rasmus

« previous php.general (#65952) next »