active record order by problem

[eluser]parvus[/eluser]
i want to use that code, which is working without any problem:

Code:

"SELECT DISTINCT `kgsim_ilceler`.`isim` AS ilce, `kgsim_mahalleler`.`isim` AS mahalle, `durum` , `kategori` , `tip` , `ozellik`
FROM (
`ilan_genel`
)
LEFT JOIN `kgsim_ilceler` ON `kgsim_ilceler`.`id` = `ilan_genel`.`ilce`
LEFT JOIN `kgsim_mahalleler` ON `kgsim_mahalleler`.`id` = `ilan_genel`.`mahalle`
ORDER BY 1 , 2, 3, 4, 5, 6"

but when i try to use same query via active record, it isn't working and says:
" Error Number: 1054

Unknown column '1' in 'order clause'

SELECT DISTINCT `kgsim_ilceler`.`isim` as ilce, `kgsim_mahalleler`.`isim` as mahalle, `durum`, `kategori`, `tip`, `ozellik` FROM (`ilan_genel`) LEFT JOIN `kgsim_ilceler` ON `kgsim_ilceler`.`id` = `ilan_genel`.`ilce` LEFT JOIN `kgsim_mahalleler` ON `kgsim_mahalleler`.`id` = `ilan_genel`.`mahalle` ORDER BY `1`, `2`, `3`, `4`, `5`, `6`

"

Code:

$this->db->distinct();
  $this->db->select('
  kgsim_ilceler.isim as ilce,
  kgsim_mahalleler.isim as mahalle,
  durum,
  kategori,
  tip,
  ozellik');
  $this -> db -> join('kgsim_ilceler', 'kgsim_ilceler.id = ilan_genel.ilce', 'left');
  $this -> db -> join('kgsim_mahalleler', 'kgsim_mahalleler.id = ilan_genel.mahalle', 'left');
  $this->db->from('ilan_genel');
  $this->db->order_by("1,2,3,4,5,6");
  $q = $this -> db -> get();

Is there a way to do it ?