Re: Using two colomns of mysql data as key/value pairs in arrays
| From: | CPT John W. Holmes | Date: | Mon, 20 Oct 2003 13:43:17 +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-31150@lists.php.net to get a copy of this message | ||
From: "Devon" <omicron9@comcast.net>
> 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.
while($r = mysql_fetch_assoc($result))
{ $array[$r['id']] = $r['name']; }
---John Holmes...