Re: Assign multiple variables from mysql_fetch_row() call
| From: | Rasmus Lerdorf | 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