Array Syntax Help

[earthlingzed]

I am pulling out a list of colors from a database and need to transform it into an associative array that will look like this:

$colors = array("red"=>"red", "blue"=>"blue","yellow"=>"yellow");

I need a little syntax help on the best way to do this. The column name from the database is 'color' and would need to be the key and the value.

I RTFM and am still stumped.

[TheDefender]

You gotta add the connect portion of your script, and change tablename to whatever your table's name is, but this little bit should help you create an array called colors where the specific color name is both the key and value.

$getcolors = mysql_query("SELECT color FROM tablename");
$colors = array();

WHILE($gotcolors = mysql_fetch_array($getcolors)){
  $colors[$gotcolors['color']] = $gotcolors['color'];
}
print_r($colors);

If this isn't what you meant, please post with more details.

[earthlingzed]

That was it! Thanks. I thought I was overlooking some simple approach.

[TheDefender]

You're welcome... Be sure to mark the thread resolved...