Re: a function for retuned vatiable
| From: | Jochem Maas | Date: | Mon, 02 Oct 2006 12:10:32 +0000 |
| Subject: | Re: a function for retuned vatiable | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-242463@lists.php.net to get a copy of this message | ||
Ross wrote:
> What I need is a quick way to assign variable names to the same value of the
> row name.
>
> example..
>
> $query= "SELECT * from $table_name WHERE sname=='hulford'";
>
> $result = mysql_query($query) or die('Error, query failed');
> while ($row=mysql_fetch_array($result)) {
>
>
> $email = $row['email'];
> $name=$row['name'];
> $address = $row['address'];
>
> //this goes on for 30 fields is there a way to automate this?
extract($row);
// OR
foreach ($row as $k =. $v) $$k = $v;
// OR just use $row['email'] etc. i.e. why make another copy of
each piece of data?
>
>
> }
>