SF Guy - 2006-05-08

i have a Menu Admin in which a user can specify whether he wants to display a particular category in the right-hand side menu or left-hand side menu.

The field used in the table for this purpose is "cat_position" and holds either the value "1"(right) or "2"(left)

now when i want to display the menu items for right menu i simply use the following SQL:

select * from categories where cat_position = 1 order by cat_order ASC

I want to know how can i implement the same functionality using PHP Layers.

Any help will be highly appreciated.