php-db | 2001051

[PHP-DB] Re: [[PHP-DB] Variable Assignment] From: Ron Patterson (ronald.patterson <email protected>)
Date: 05/02/01

Assuming this may be MySQL, use a mysql_fetch_object like:

$result=mysql_query($sql);
$r=mysql_fetch_object($result);
echo $r->real_name;

Other databases have similar syntax.

Hope this helps,
Ron Patterson
USA.NET

"Rankin, Randy" <randy.rankin <email protected>> wrote:
> All:
>
> I am new to PHP and was hoping for some input to what is probably an 'easy'
> question.
>
> The following SQL statement returns 1 row:
>
> $sql = "SELECT id, real_name FROM authorization WHERE username='$username'
> and password='$password'";
>
> All I want to do is assign the results of the field real_name to a variable
> called $salesperson, but I cannot seem to get it to work.
>
> Thanks inadvance for your help,
>
> Randy Rankin
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>

____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>