• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.