Help with sql query

[eluser]Unknown[/eluser]
hi,
I have an sql query which works fine, but I am having real trouble trying to convert it to codeigniter active record!

function getSnippets($question_number) {

$result = mysql_query(

"SELECT

(SELECT answer FROM codePiece WHERE id = cp1) AS answer1,
(SELECT answer FROM codePiece WHERE id = cp2) AS answer2,
(SELECT answer FROM codePiece WHERE id = cp3) AS answer3,
(SELECT answer FROM codePiece WHERE id = cp4) AS answer4,
(SELECT answer FROM codePiece WHERE id = cp5) AS answer5

FROM question
WHERE question.id = $question_number");


if(!$result){
echo mysql_error();

}

$snippetsArray = array();
while ($record = mysql_fetch_assoc($result)){
array_push($snippetsArray, $record);

}

return $snippetsArray;

}

If anyone could help, or even make a suggestion that would be such a great help as I am still new to CI and have tried so many different solutions but nothing works .

Thankyou in advance!