Re: mysql_result()
| From: | Phil Jackson | Date: | Thu, 05 Apr 2001 04:39:57 +0000 |
| Subject: | Re: mysql_result() | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8239@lists.php.net to get a copy of this message | ||
Looks reasonable enough....
LeTourneau - hmmm - Longview, Texas?
Phil J.
Mark Roedel wrote:
> > -----Original Message-----
> > From: Jordan Elver [mailto:jjelver@worldsites.net]
> > Sent: Wednesday, April 04, 2001 10:46 AM
> > To: PHP Database Mailing List; PHP General Mailing List
> > Subject: [PHP-DB] mysql_result()
> >
> >
> > If I knnow that a query will only retrun one row, can I do
> > this (below) rather than using a while loop for one record?
> >
> > $id = @mysql_result($result, 0, 'id');
> > $name = @mysql_result($result, 0, 'name');
> > $email = @mysql_result($result, 0, 'email');
> > $address1 = @mysql_result($result, 0, 'address1');
> > $address2 = @mysql_result($result, 0, 'address2');
> > $town_city = @mysql_result($result, 0, 'town_city');
> > $postcode = @mysql_result($result, 0, 'postcode');
>
> Looks reasonable to me...what happens when you try it?
>
> ---
> Mark Roedel (roedelm@letu.edu) || "There cannot be a crisis next week.
> Systems Programmer / WebMaster || My schedule is already full."
> LeTourneau University || -- Henry Kissinger
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net