On Mon, October 2, 2006 7:08 am, 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=m
extract() - http://www.php.net/extract - does what you are after.
However often it's easier to handle the array as you have a better idea
of what variables are available, particularily if you are working with
multiple tables.
Ross wrote:
> What I need is a quick way to assign variable names to th
Not actually sure what you want, but this might do it :)
$j = 0;
While($Row = mysql_fetch_array($Result)) {
$email[$j] = $Row['email'];
...
...
$j++;
}
-Original Message-
From: Ross [mailto:[EMAIL PROTECTED]
Sent: Monday, October 02, 2006 7:09 PM
To: php-
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)) {
>
4 matches
Mail list logo
