[eluser]R_Nelson[/eluser]
I ended up solving it my self this is the query
Code:
$this->db->where('date >=',date('Y-m-d'))->order_by('date','asc');
$data['query'] = $this->db->get('calendar');
i know i can put ->limit(1) at the end of my chain and even chained in the get() but i decided i want to take it a step further and see if the DB date is today and if it is i'm gonna display that one and the next show if not i'm not gonna care about anything else that shows up!