Re: Using two colomns of mysql data as key/value pairs in arrays
| From: | Ignatius Reilly | Date: | Mon, 20 Oct 2003 13:36:49 +0000 |
| Subject: | Re: Using two colomns of mysql data as key/value pairs in arrays | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31149@lists.php.net to get a copy of this message | ||
mysql_fetch_array( $result )
_________________________
----- Original Message -----
From: "Devon" <omicron9@comcast.net>
To: <php-db@lists.php.net>
Sent: Monday, October 20, 2003 3:30 PM
Subject: [PHP-DB] Using two colomns of mysql data as key/value pairs in
arrays
> I have been scouring the online documentation and experimenting for
> hours trying to find a solution. I just can't do it.
>
> I have two colomns of data that I am retrieving from MySQL:
>
> SELECT id, name FROM a_table;
>
> I just cannot figure out how to get that data from the resource handle
> into an associative array with the 'id' colomn making up the keys and
> the 'name' colomn making up the values.
>
> Any help would be wonderful! :)
>
>
>
> Using PHP 4.3.3 on Linux if it matters.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>