[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!