Re: Using two colomns of mysql data as key/value pairs in arrays
| From: | jeffrey_n_Dyke at Keane dot com | Date: | Mon, 20 Oct 2003 13:40:37 +0000 |
| Subject: | Re: Using two colomns of mysql data as key/value pairs in arrays | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31151@lists.php.net to get a copy of this message | ||
$qry = "SELECT id, name FROM a_table";
$result = mysql_query($qry) or die(mysql_error());
while ($rs = mysql_fetch_row($result)) {
$myarray[$rs[0]] = $rs[1];
}
is that waht you need?
hth
Jeff
Devon
<omicron9@comcast To: php-db@lists.php.net
.net> cc:
Subject: [PHP-DB] Using two colomns of mysql data as
key/value pairs in arrays
10/20/2003 09:30
AM
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