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

Reply via email to