Mysql query issue

Hello all,

I'm working on my second website using PHP and MySQL after completing the PHP development course but as I expected I'm already pretty stuck with a query. Ok so, I'm making a ecommerce computer website which has multiple tables in the database, one for products, then other ones for processors, graphics cards, motherboards etc. My products table has a bunch of id columns such as 'motherboard_id', 'processor_id' which I'm trying to use when joining the tables together. The query I am writing looks like this:

SELECT products.name, processors.name, graphics.name FROM products LEFT OUTER JOIN processors ON products.processor_id = processors.id LEFT OUTER JOIN graphics ON products.graphics_id = graphics.id
WHERE products.id = 2;

This is just a test query to see if the join works, and in phpmyadmin, it works fine, it returns the name of the product, the name of its processor, and the name of its graphics card. But, if I try to run it in PHP like this:

    try {
        $results = $db->query("SELECT products.name, processors.name, graphics.name FROM products LEFT OUTER JOIN processors ON products.processor_id = processors.id LEFT OUTER JOIN graphics ON products.graphics_id = graphics.id WHERE products.id = 2;");
    } catch (Exception $e) {
        echo "Data could not be retrieved.";
        exit;
    }

    echo "<pre>";
    $row = $results->fetchAll(PDO::FETCH_ASSOC);
    var_dump($row);
    exit;

It only returns one row, like this:

array(1) {
  [0]=>
  array(1) {
    ["name"]=>
    string(15) "Nvidia Graphics"
  }
}

Really need some help with this please! :)

Thanks, Adam