function get_name($id, $type)
{
$getrs = new Dedesql(falsh);
switch ($type) {
case "dw":
$query = "select dwname from #@__dw where id='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['dwname'];
break;
case "categories":
$query = "select categories from #@__categories where id='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['categories'];
break;
case "name":
$query = "select cp_name from #@__basic where cp_number='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['cp_name'];
break;
case "gg":
$query = "select cp_gg from #@__basic where cp_number='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['cp_gg'];
break;
case "gys":
$query = "select cp_gys from #@__basic where cp_number='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['cp_gys'];
break;
case "dwname":
$query = "select cp_dwname from #@__basic where cp_number='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['cp_dwname'];
break;
case "lab":
$query = "select l_name from #@__lab where id='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['l_name'];
break;
case "bcate":
$query = "select cp_categories from #@__basic where cp_number='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['cp_categories'];
break;
case "scate":
$query = "select cp_categories_down from #@__basic where cp_number='{$id}'";
$getrs->Setquery($query);
$getrs->execute();
$row = $getrs->GetOne();
return $row['cp_categories_down'];
break;
}
$getrs->close();
}
