Cacher is the code snippet organizer for pro developers

$oDb        = oxDb::getInstance();
$oCategory  = oxNew('oxcategory');
$oCategory->setLanguage($this->getLanguage());

$sWhere   = $oCategory->getSqlActiveSnippet();
$sSelect  = 'SELECT * FROM
  oxcategories
  WHERE oxcategories.oxid = \'' . $oDb->escapeString($sOxid) . '\'';

if($oCategory->assignRecord($sSelect)) {
  return $oCategory;
}