 |
 |
Find a programming school near you
php-db | 2001041
Date: 04/04/01
- Next message: Gabriel: "[PHP-DB] Method POST not allowed"
- Previous message: Mark Roedel: "RE: [PHP-DB] mysql_result()"
- In reply to: Jordan Elver: "[PHP-DB] mysql_result()"
- Next in thread: Jordan Elver: "Re: [PHP-DB] mysql_result()"
- Reply: Jordan Elver: "Re: [PHP-DB] mysql_result()"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Jordan,
If you know your result is going to product one row, try using:
$row=mysql_fetch_array($result, MSQL_ASSOC);
// returns an assoc array where the field names are keys, field value is
value
$id=row[id];
$name=row[name];
etc.
Best regards,
Andrew
--------------------------------------
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness Infrastructure Technology
http://www.openlinksw.com
-----Original Message-----
> From: Jordan Elver [mailto:jjelver <email protected>]
> Sent: Wednesday, April 04, 2001 11:46 AM
> To: PHP Database Mailing List; PHP General Mailing List
> Subject: [PHP-DB] mysql_result()
>
>
> Hi,
> If I knnow that a query will only retrun one row, can I do thiss (below)
> rather than using a while loop for one record?
>
> $id = <email protected>($result, 0, 'id');
> $name = <email protected>($result, 0, 'name');
> $email = <email protected>($result, 0, 'email');
> $address1 = <email protected>($result, 0, 'address1');
> $address2 = <email protected>($result, 0, 'address2');
> $town_city = <email protected>($result, 0, 'town_city');
> $postcode = <email protected>($result, 0, 'postcode');
>
> Cheers,
>
> Jord
>
> --
> 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>
>
>
-- 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>
- Next message: Gabriel: "[PHP-DB] Method POST not allowed"
- Previous message: Mark Roedel: "RE: [PHP-DB] mysql_result()"
- In reply to: Jordan Elver: "[PHP-DB] mysql_result()"
- Next in thread: Jordan Elver: "Re: [PHP-DB] mysql_result()"
- Reply: Jordan Elver: "Re: [PHP-DB] mysql_result()"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
