Build an array from values in a table?

[jjfletch]

Hi there,

I'm a little puzzled (or not thinking clearly). I've simplified my needs in the example below, but would appreciate any help/guidance.

I have a table "Colors" that contains two fields, ID and Color_Name. There are five records in the table:

1 red
2 blue
3 green
4 yellow
5 gold

I'd like to build an array based on these values. Something that will look like this:

$array = array('red', 'blue', 'green', 'yellow', 'gold');

But, I'd like to do this via a query to the db. I'm not sure how to go about something like this. Can anyone provide an example?

[leatherback]

Hi,

do something like this:
assumed: id = first colum, name = secod colum

//do your query the normal way:
$query = "select * from table order by id";
   $result = mysql_query($query);


// set an array: 
$lookup_array = array();

// get results out:
while($row = mysql_fetch_array($result))
  {
  $id = $row['id'];
  $lookup_array[$id] = $row['name'];
  }

// show the result:
print_r($lookup_array);