Welcome Guest, Not a member yet? Register   Sign In
FROM is adding 1 to SQL..
#1

Hi,

I have a problem with FROM. I am trying a join two tables, but the FROM function is adding 1 number to SQL sentences.

My codes : 

PHP Code:
$company $ci->db->select('MUST.*, PERS.*')->from('musteriler as MUST')
                        ->
join('ilgili_kisiler AS PERS''PERS.musteri_id = MUST.id''inner')
                        ->
get_where(array('PERS.id' => $person_id)); 


Output:

Code:
SELECT `MUST`.*, `PERS`.* FROM (`musteriler` as `MUST`, 1) INNER JOIN `ilgili_kisiler` AS `PERS` ON `PERS`.`musteri_id` = `MUST`.`id`


You can see there is a 1 number in FROM ... 

How can I fix this ?
Reply


Messages In This Thread
FROM is adding 1 to SQL.. - by sDenizhan17 - 06-28-2018, 08:06 AM
RE: FROM is adding 1 to SQL.. - by php_rocs - 06-28-2018, 09:12 AM
RE: FROM is adding 1 to SQL.. - by sDenizhan17 - 07-02-2018, 02:23 AM
RE: FROM is adding 1 to SQL.. - by dave friend - 06-28-2018, 04:22 PM
RE: FROM is adding 1 to SQL.. - by sDenizhan17 - 07-02-2018, 02:22 AM
RE: FROM is adding 1 to SQL.. - by dave friend - 07-02-2018, 12:41 PM
RE: FROM is adding 1 to SQL.. - by sDenizhan17 - 07-03-2018, 02:04 AM
RE: FROM is adding 1 to SQL.. - by php_rocs - 07-02-2018, 11:39 AM



Theme © iAndrew 2016 - Forum software by © MyBB