Hello, In my application, a user can bookmark articles. So I have a table article, user, and a table selections that associate a user with an article. I want to create a webpage which will show the list of the favorite articles of the connected user. So I have something like:
$selections = new Selections(); $order = array( 'article_id' ); $count = 12; $where = array( 'member_id = ?' => $auth->getIdentity()->id_member ); $userSelections = $selections->fetchAll($where, $order, $count, 0); Now I have the selections (I use a limit because I use a pager), but now I have to get each article in the selection and I need to check some conditions on them. (e.g. field "to_delete" must be 0, etc.) How can I get the articles with conditions ? Maybe I should not use Zend_Db_Table or this and have just one big query ? Thank you very much for any help ! -- View this message in context: http://www.nabble.com/DB-relationship%2C-help-tp14248732s16154p14248732.html Sent from the Zend Framework mailing list archive at Nabble.com.
