Anonymous

$products = Doctrine::getTable('Product') -> findAll();
foreach($products as $p)
  echo $p -> name.' - '.$p -> Company -> id.'<br />';