sql table to array

[clandmeter]

Hi,

 

I have a simple task which i can seem to solve.

 

I have a table in my database like this:

 

id      fruit      color

1      apple    green

2      banana  yellow

.......

 

Now i want to create an array where to key is the id and the value is the fruit.

array(1 => apple, 2 => banana, .....)

 

How would i do this with php/mysql?

 

TIA,

 

Carlo

[rajivgonsalves]

you must of written some code ?

[clandmeter]

you must of written some code ?

 

Not sure if i understand your question.

 

I am trying to create a Drupal cms module in php.

 

This is what i tried but its not correct:

 

<?php 
  $query = ("SELECT * FROM {table}");
  $result = db_query($query);
  while ($row = db_fetch_array($result)) {
    $ptype = array($row[id] => $row[type]);
  }
?>

 

Now everytime it looks it will rewrite the array so in the end it only holds the last row.

What I want is that it holds all the rows in that array so the id's are the keys and the values are the type.

 

Hope this is clearer now.

 

Carlo

 

[rajivgonsalves]

your code should be

 

<?php 
  $query = ("SELECT * FROM {table}");
  $result = db_query($query);
$ptype = array();
  while ($row = db_fetch_array($result)) {
    $ptype[$row[id]] = $row[type];
  }

print_r($ptype);
?>

 

 

hope its helpful

[clandmeter]

That seems to work nicely  .

Thank you!

 

Didn't know i could do it this way with arrays.

 

 

Carlo

[rajivgonsalves]

you can check out

 

http://php.net/array

 

there are fine examples out there