Ignatius, the original poster mentioned "an associative array" - The mysql_fetch_assoc() function fetches an associative array. If you want only that, use that function, if you want indices, use the mysql_fetch_row() function. If for some reason you need both, then you should use the mysql_fetch_array() function; don't assign what you won't use.
-- Jon Kriek http://phpfreaks.com "Ignatius Reilly" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > mysql_fetch_array( $result ) > > _________________________ > ----- Original Message ----- > From: "Devon" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php