Help with sql query

[eluser]rufnex[/eluser]
Hi,

you can try something like that:

$this->db->select('(select answer from codePiece where id = cp1) as answer1');
$this->db->select('(select answer from codePiece where id = cp2) as answer2');
$this->db->select('(select answer from codePiece where id = cp3) as answer3');
$this->db->select('(select answer from codePiece where id = cp4) as answer4');
$this->db->select('(select answer from codePiece where id = cp5) as answer5');
$this->db->where('id', $question_number);
$query = $this->db->get('question');
if($query->num_rows() > 0)
{
print_r($query->result_array());
}