Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Arranging by months_total query
Post: RE: Arranging by months_total query

$query = $this->db->query(" select groups.id,groups.groupname, sum(if( MONTH(timestamp) = 1, price, 0 )) as January, sum(if( MONTH(timestamp) = 2, price, 0 )) as February, sum(if( MONTH(time...
2,452 Views
0 Replies
01-21-2015, 10:13 PM
rajneeshgobin
    Thread: Help Active Records Query
Post: RE: Help Active Records Query

try something like this $this->db->select('id'); $this->db->select('name'); $this->db->select('dob'); $this->db->where('group_id',666); $this->db->where('fname','devid'); $this->db->or_wh...
4,069 Views
0 Replies
01-20-2015, 04:42 AM
rajneeshgobin
    Thread: Arranging by months_total query
Post: Arranging by months_total query

hello , in my senario, students can make entries in the database whole year round entering the number of cash they spent on diferent items. basically the table is like this id,timestamp,username...
2,452 Views
0 Replies
01-20-2015, 04:36 AM
rajneeshgobin
    Thread: how can i write this query
Post: how can i write this query

i need a query which will delete duplicate entries from my database. the query below tells me which rows of my table has duplicates based on the selected parameters in this case role id and perm id...
6,566 Views
0 Replies
11-04-2014, 10:42 PM
rajneeshgobin

Theme © iAndrew 2016 - Forum software by © MyBB