How to select and move all fields?

The following code is being retrofitted for another similar task:
$sql="select from CandidateCC where CandidateID=".$values["CandidateID"];

$rs=CustomQuery($sql);

$CanCCData=db_fetch_array($rs);
global $conn,$strCandidateCC;

//Put all fields below (is there a way to do this with one command?)

$strSQLSave = "INSERT INTO RecruiterApproved (RecruiterID,Recruiting_Company_Name) values (";

$strSQLSave .= $CanCCData["RecruiterID"].",";

$strSQLSave .= chr(34).$CanCCData['Recruiting_Company_Name'].chr(34);

$strSQLSave .= ")";

db_exec($strSQLSave,$conn);
It works, but for two fields. How can I move 30 fields? Do I have to type each and every one in, or can I use the to select all and move all?
If I have to do them by hand, how do I format times and dates? Are uploads considered strings?
Mike