hi adrian, many thanks for your tip. it works fine. kind regards martin -----Ursprüngliche Nachricht----- Von: Adrian Ciutureanu [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 12. Juli 2001 15:46 An: Martin Lucas Cc: [EMAIL PROTECTED] Betreff: RE: [PHP] associative arrays $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]
