php Programming Glossary: andwhere
Complex WHERE clauses using the PHP Doctrine ORM http://stackoverflow.com/questions/1049617/complex-where-clauses-using-the-php-doctrine-orm currently have in my PHP code is this where 'name ' 'ABC' andWhere 'category1 ' 'X' orWhere 'category2 ' 'X' orWhere 'category3.. ' 'X' orWhere 'category2 ' 'X' orWhere 'category3 ' 'X' andWhere 'price ' 10 But this produces something like WHERE name 'ABC'.. results. Also is there a difference between the where andWhere and addWhere methods UPDATE Ok it seems like you can't do complex..
Database and query to store and retreive friend list http://stackoverflow.com/questions/8208073/database-and-query-to-store-and-retreive-friend-list leftJoin 'mf.users as friend' where mf.user_id 25 andWhere mf.approved 1 Suppose I am viewing the user no. 25 . With this..
|