Welcome Guest, Not a member yet? Register   Sign In
Left outside Join in Code Igniter
#1

So here's the question: I'm not sure how to write on code igniter; I read an article about it here, thus I want to insert my "And" statement before the where. The query works, but I'm not sure what the syntax is in code igniter. Thank you in advance for any assistance.
Code:
Select c.c_id, c.c_name, p.phone_no FROM Company AS c
LEFT OUTER JOIN Phone AS p
ON p.p_flex_id=c.c_id
AND p.g_id'='1' AND p.ct_id='3'
WHERE 1
Reply
#2

@leusiam , There are multiple ways for you to do this. What version of CI are you using?
Reply
#3

(01-23-2023, 09:43 AM)php_rocs Wrote: @leusiam ,  There are multiple ways for you to do this.  What version of CI are you using?

yes can you please explain the ways and i am using 3.0.6
Reply
#4

@leusiam , Here is the documentation that will assist you... https://codeigniter.com/userguide3/datab...ery-basics
Reply
#5

Thanks you for your help
Reply




Theme © iAndrew 2016 - Forum software by © MyBB