I'm using this code:-
PHP Code:
require_once( BASEPATH .'database/DB.php' );
$db =& DB();
$query = $db->get( 'shop_product_category' );
$result = $query->result();