How can I make this array with data from a database?

Question

$array=array("a"=>"Apple","b"=>"Ball","c"=>"Cat");

I have a database table with column letter and value.

letter | value
       |
  a    | Apple
  b    | Ball
  c    | Cat

I want "a"=>"Apple","b"=>"Ball","c"=>"Cat" to be values from the database, using for loop, how is that possible?

Many thanks for any help!

first question, what database?

user557846
– user557846

2011-09-13 07:29:12 +00:00
Commented Sep 13, 2011 at 7:29 — user557846
– user557846, Commented Sep 13, 2011 at 7:29
thanks for your response @Dagon, its MySql..

Emkey
– Emkey

2011-09-13 07:30:04 +00:00
Commented Sep 13, 2011 at 7:30 — Emkey
– Emkey, Commented Sep 13, 2011 at 7:30

user557846 · Accepted Answer · 2011-09-13 07:32:33Z

10

assuming you can do the connection and select

$array=array();
while ($row = mysql_fetch_assoc($result)) {
    $array[$row['letter']]=$row['value'];
}

print_r($array);

answered Sep 13, 2011 at 7:32

user557846

Sign up to request clarification or add additional context in comments.

2 Comments

Emkey Over a year ago

Wow! I got the idea from your answer, thanks @Dagon! I just made a little modification based on my needs: $options=array(); foreach ($products as $key => $value){ $options[$value]=$value; }

user557846 Over a year ago

your code does no make much sense related to the question above, your just reformatting an existing array taking the values from one to make another with matching key values pairs, which is a little pointless

Collectives™ on Stack Overflow

How can I make this array with data from a database?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related