On Thu, Apr 4, 2013 at 2:06 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:

Suppose I have a tasks table which contains tasks created by several people and where each task can be assigned to any other user,
with columns like these:

status - A string value, can be Open, In Progress or Closed
created_by - int value, stores the id of the user who created the task
assigned_to - int value, stores the id of the user assigned to a task

And I want to see only open tasks created by or assigned to me, i.e. the query:

SELECT * FROM tasks WHERE status = 'Open' AND (created_by = 3 OR assigned_to = 3)

How can I do this using CodeIgniter ActiveRecord?

--
Regards,
Peter Karunyu
-------------------

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

--
Ian Vuyayi Madege

Software engineer

As a programmer a computer will always do what you command it to do.