fetching arrays php and mysql

[ukgimp]

It is Friday and what I know is a simple task, is baffling me.

I have a function that uses and array in the following format.

$cat = array("1"=>"All","2"=>"red","3"=>"yellow","4"=>"green");

I have those recpective values in a db and can get them out easily with a query.

$sql = mysql_query("SELECT id, colour FROM category_two");
$test = mysql_fetch_array($sql, mysql_ASSOC);

But converting them into the above format is not hapening. All I get is one value. Can I not just grab the whole array in one go or do I need to build it up with some sort of while statement?

It has always confused me this array stuff :(

Does the above make sense.

[coopster]

Correct, you need to loop to get the values loaded into your array:

$sql = mysql_query("SELECT id, colour FROM category_two");
while ($test = mysql_fetch_array($sql, mysql_ASSOC)) {
$cat[] = $row['colour'];
}

[ukgimp]

Thanks Coop'

At least I am not mad. I just needed to clear that up. Probably saved me endless messing around.

Cheers

[ukgimp]

I was dealing with a multi dimentional array so here is the solution that I got working

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$key = $row[0];
$value = $row[1];
$myarray[$key]="$value";
}