Creating an array from DB results

[camcim]

Hi all,
If i have the following:

$sql = "SELECT * FROM company_categories WHERE company_id='$id'";
    $result = mysql_query($sql);
    while($row = mysql_fetch_array($result)){
    $comp_cat_id = $row["comp_cat_id"];
    $company_id = $row["company_id"];
    $category_id = $row["category_id"];

echo "$category_id";

how can i get the $category_id into an array?

Cheers,
camcim

 

[skiflyer]

$cat_array = array();

$cat_array[] = $category_id;

or if you want to know the specific index...

$cat_array['apples'] = $category_id;
$cat_array[1] = $category_id;

The initial call to $cat_array = array(); may be optional (I can't remember off hand), but it certainlly won't hurt things.

-Rob