Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #3 [insert_id:protected] => [sql:protected] => SELECT id ,seq ,brandName ,descriptiveText ,brandLogo ,urlName ,createDate ,updateDate FROM ProductBrand ORDER BY seq,brandName [current_row:protected] => 0 [total_rows:protected] => 4 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #6 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 1 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 32 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #8 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 3 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 15 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #10 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 4 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 12 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #12 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 5 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 5 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #15 [insert_id:protected] => [sql:protected] => SELECT * FROM ProductBrand WHERE urlName = 'chocolate-inn' [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #3 [insert_id:protected] => [sql:protected] => SELECT id ,seq ,brandName ,descriptiveText ,brandLogo ,urlName ,createDate ,updateDate FROM ProductBrand ORDER BY seq,brandName [current_row:protected] => 0 [total_rows:protected] => 4 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #6 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 1 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 32 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #8 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 3 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 15 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #10 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 4 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 12 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #12 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 5 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 5 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #22 [insert_id:protected] => [sql:protected] => SELECT * FROM V_BrandNavigation WHERE brandid = 3 ORDER BY brandSeq, ParentSeq, ChildSeq [current_row:protected] => 0 [total_rows:protected] => 38 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #24 [insert_id:protected] => [sql:protected] => SELECT keywords FROM V_ProductCategories WHERE CategoryID = 0 [current_row:protected] => 0 [total_rows:protected] => 0 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #27 [insert_id:protected] => [sql:protected] => --function getFeaturedByBrand(3) SELECT * FROM V_FeaturedProductsByBrand WHERE LocaleID = 1 AND brandId = 3 ORDER BY isFeatured DESC, sortFeatured ASC [current_row:protected] => 0 [total_rows:protected] => 25 ) NC Custom / Chocolate Inn:
  
×

Follow Us

 
Top