Query Problem

[eluser]tolgay[/eluser]
[quote author="jmadsen" date="1340793814"]try

Code:

$this->db->select("*", FALSE );

but I find it to be unreliable at times[/quote]

I used this

Code:

$this->db->select("*",false);
$this->db->from('arkadaslar');
$this->db->join('uyeler','uyeler.id=(arkadaslar.uid+arkadaslar.fid)-1)');
$this->db->get();

But it didn't work.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

SELECT * FROM (`arkadaslar`) JOIN `uyeler` ON `uyeler`.`id`=(`arkadaslar`.`uid+arkadaslar`.`fid)-1)`