Lấy Cid & Catid

#### CID
function getCategory($mid=1){

global $db,$prefix;

$query= "SELECT cid from ".$prefix."_shop_categories  where mid=$mid";
$new = $db->sql_query($query);
$data = $db->sql_fetchrowset($new);
$whe="";
if(empty($data)) return $whe;

for($i=0,$n=count($data);$i<$n;$i++){
$row=$data[$i];
$whe.= "cid = ".$row["cid"];
if($i<$n-1)
$whe.=" or ";
}
return "(".$whe.")";
}

function getCid($cid){

global $db,$prefix;

$query= "SELECT cid from ".$prefix."_shop_categories  
where parentid= ".$cid."";
$new = $db->sql_query($query);
$data = $db->sql_fetchrowset($new);
$whe="";
if(empty($data)) return $whe;

for($i=0,$n=count($data);$i<$n;$i++){
$row=$data[$i];
$whe.= "cid = ".$row["cid"];
if($i<$n-1)
$whe.=" or ";

}
return "(".$whe.")";
}
#### CATID
function getWhereCat($name="",$home=1){

global $db;

$query= $this->_buildQuery($name,$home);
$new = $db->sql_query($query);
$data = $db->sql_fetchrowset($new);
if(empty($data)) return "";
$whe="";
for($i=0,$n=count($data);$i<$n;$i++){
$row=$data[$i];
$whe.= "catid = ".$row["catid"];
if($i<$n-1)
$whe.=" or ";
}
return "(".$whe.")";
}
function getModID($name=""){

global $db,$prefix;

$query= "SELECT *  FROM ".$prefix."_modules b  WHERE b.title='".$name."'";
$new = $db->sql_query($query);
$data = $db->sql_fetchrow($new);
if(empty($data)) return "";
return  $data['mid'];

}