Welcome Guest, Not a member yet? Register   Sign In
Tranform mysql sql into codeigniter query
#1

Hello,

I have this mysql select:

Code:
SELECT id, zile, status, nr_inmatriculare,title,start_date,end_date,doc_type, contact_emails
           FROM (SELECT datediff(cd.end_date,curdate())  as zile, c.id,
                      c.nr_inmatriculare, c.status,cd.title,cd.end_date,cd.start_date, cd.doc_type, c.contact_emails
                         FROM car_docs cd
                         INNER JOIN cars c ON c.id = cd.car_id
                         WHERE c.status > 0

                       ) as s WHERE zile > -2190 AND title LIKE 'ITP' ORDER BY zile ASC
 
And I'm trying to tranform it into codeigniter query this is what I done:

Code:
return $this->db->select('id, zile, status, nr_inmatriculare,title,start_date,end_date,doc_type, contact_emails')
                   ->where('DATEDIFF(cd.end_date, current_date) as zile, c.id, c.nr_inmatriculare, c.status, cd.title, cd.end_date, cd.start_date, cd.doc_type, c.contact_emails')
                   ->from('car_docs cd')
                   ->join('cars c','c.id = cd.car_id','inner')
                   ->where('c.user_id',$this->session->userdata['user_id'])
                   ->where('c.status >',0)
                   ->where('zile >' ,-2190)
                   ->like('title', 'ITP')
                   ->order_by('zile', 'ASC')
                   ->get()->result();

But is not working. What I need to change?
Reply
#2

Please explain what "not working" means.
What, if any errors are you getting?
How are the results not what is expected?
Reply




Theme © iAndrew 2016 - Forum software by © MyBB