db_fetch_array() fetches only one row from data table, even though I am expecting multiple results I'm trying to create an array with all the group node' IDs, and from outside group context.
I currently have two group nodes defined, and I can see them in my OG table.

However I only get back one result, using the following code. I've tried using only db_query() without db_fetch_array() and I still get a single result.

$group_node_nids = db_fetch_array(db_query("SELECT nid from {og}"));


What am I missing here?
Every time I have to take results outs of a database query result resource I'm scratching my head wondering why we don't have a way to return all rows without having to iterate over the object.  Perhaps there's a method out there in cTools or Drupal 7 but until a better answer is presented:

$results = db_query("SELECT nid from {og}");
while($row = db_fetch_array($results)) { 
  $group_node_nids[] = $row['nid'];
}