hai i need a help very badly,
i have some problems with a database query, iam new to ci.
i will mention the problem here,
3 tables
table names
1) film(film_id, filmname) PK (film_id)
2) category(category_id, categoryname) PK (category_id)
3) film_category(contains both primary keys (film_id) and (category_id))
the problem is i want to select all filmname from film tables where category_id= 3.
how to do this with active record class.
please make a suggestion.
iam new to ci. i love it.
thankyou in advance.
from your friend.