$result = mysql_db_query("database","select item1, item2 from table");
while ($row = mysql_fetch_array($result)) {
        $myArray[$row['item1']] = $row['item2'];
}

> -----Original Message-----
> From: Martin Lucas [mailto:[EMAIL PROTECTED]]
> Sent: 12 iulie 2001 16:25
> To: '[EMAIL PROTECTED]'
> Subject: [PHP] associative arrays
> 
> 
> Hi everybody
> i have the following database query:
> 
> $result=mysql_db_query("database","select item1,item2 from table");
>       while ($row=mysql_fetch_array($result)){
>               $a=$row[item1];
>               $b=$row[item2];
>       
>       }
> what i need is an associative array, with $a as key and $b as value,
> containing each item1 and item2 from the database
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 
> 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to