By navs on

I have a user role called "Learner" and they are each assigned a grade, the class they belong to.

I want a view as a block where only the books that relate to that grade level will be shown.
My SQL Statement generated in views should be along these lines:

Select all Books where Book->Depth= 1 and User->Grade = Book->Grade

I want students to see the books meant for their class alone, and not all the books available.

How can I do this?
Thanks
Navs

⋅ Categories: Drupal 6.x