Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming Active record and date in where statement
Active record and date in where statement
  • El Forum
    Unregistered
  •  
#7
07-21-2010, 02:57 PM

[eluser]smilie[/eluser]
Hi mddd,

I am only using count_all_results. I am at home now so I can post code itself tommorow. But I have 6 separate queries and only those with date function do not work.

From the top of the head, full code is:
$this->db1->where('sth',$date);
$this->db1->from('table');
$do = $this->db1->count_all_results();
return $do;

Without date expression it is working.

Sorry for any mistakes I am typing from mobile.

Regards,
Smilie


Messages In This Thread
Active record and date in where statement - by El Forum - 07-21-2010, 09:14 AM
Active record and date in where statement - by El Forum - 07-21-2010, 09:36 AM
Active record and date in where statement - by El Forum - 07-21-2010, 09:37 AM
Active record and date in where statement - by El Forum - 07-21-2010, 09:44 AM
Active record and date in where statement - by El Forum - 07-21-2010, 09:53 AM
Active record and date in where statement - by El Forum - 07-21-2010, 01:29 PM
Active record and date in where statement - by El Forum - 07-21-2010, 02:57 PM
Active record and date in where statement - by El Forum - 07-21-2010, 09:16 PM
Active record and date in where statement - by El Forum - 07-22-2010, 12:35 AM
Active record and date in where statement - by El Forum - 07-22-2010, 02:06 AM
Active record and date in where statement - by El Forum - 07-22-2010, 02:16 AM
Active record and date in where statement - by El Forum - 07-22-2010, 02:31 AM
Active record and date in where statement - by El Forum - 07-22-2010, 02:40 AM
Active record and date in where statement - by El Forum - 07-22-2010, 02:49 AM
Active record and date in where statement - by El Forum - 07-22-2010, 04:11 AM
Active record and date in where statement - by El Forum - 07-22-2010, 04:18 AM
Active record and date in where statement - by El Forum - 07-22-2010, 04:29 AM
Active record and date in where statement - by El Forum - 07-22-2010, 04:37 AM
Active record and date in where statement - by El Forum - 07-22-2010, 05:31 AM
Active record and date in where statement - by El Forum - 07-22-2010, 05:50 AM
Active record and date in where statement - by El Forum - 07-22-2010, 05:54 AM
Active record and date in where statement - by El Forum - 07-22-2010, 06:03 AM
Active record and date in where statement - by El Forum - 07-22-2010, 06:16 AM
Active record and date in where statement - by El Forum - 07-22-2010, 06:31 AM
Active record and date in where statement - by El Forum - 09-25-2010, 10:47 PM



Theme © iAndrew 2016 - Forum software by © MyBB