From: "Devon" <[EMAIL PROTECTED]>
> 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...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php