FuelPHP Forums

Hey, I'm looking for a best practise solution for this problem: I query the database with an SELECT statement with Limit and Offset, but I also want to have the total numbers of results, so I execute 2 queries right now:

// total
$query = Model_Artist::find($artistId, array(
                    'related' => array(
                        'products'
                    ),
                ));
        $total = $products->count();

// the wanted products
$query = Model_Artist::find($artistId, array(
                    'related' => array(
                        'products' => array(
                            'order_by' => array('products.id' => 'DESC'),
                            'limit' => $limit,
                            'offset' => $start,
                        ),
                    ),
                ));
$products = $query->to_array();

Is there a nicer / quicker / prettier way for this? I know that MySQL has an option (Found rows):
http://dev.mysql.com/doc/refman/5.1/en/information-functions.html#function_found-rows Thanks in advance!