FROM is adding 1 to SQL.. |
(07-02-2018, 02:22 AM)sDenizhan17 Wrote:(06-28-2018, 04:22 PM)daveĀ friend Wrote: The first argument to get_where should be the name of the table. Fix that and see what happens. Your code PHP Code: ->get_where(array('PERS.id' => $person_id)); supplies only one argument. Try PHP Code: ->get_where('PERS', array('PERS.id' => $person_id)); On further consideration, you could probably do this PHP Code: $company = $ci->db I believe that select('*') in combination with the join statment will give you all fields from both tables. |
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
|