Doctrine: Select elements that are related to one or more items in many-to-many relation

Posted by Migol on Stack Overflow See other posts from Stack Overflow or by Migol
Published on 2010-03-17T16:22:16Z Indexed on 2010/03/17 16:51 UTC
Read the original article Hit count: 179

Filed under:

doctrine

|

php

|

query

|

count

I have a category system that is related many-to-many with posts. How can I select a list of those categories that are related to one or more posts?

$q = Doctrine_Query::create()
     ->from('Category c')
     ->where('<DONT KNOW WHAT TO WRITE>')
     ->select('c.name');

© Stack Overflow or respective owner

Related posts about doctrine

Doctrine::Windows::How generate Doctrine Models on windows?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How generate Doctrine Models from database on windows? (I working with zend studio and zend framework) >>> More
Dotrine::Zend::How generate new doctrine models without delete doctrine models classes with my code

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I build zend app with doctrine. The problem is when i add new tables to database and I should generate doctrine models, because I add my own code to Doctine generated classes- I dont wont to delete them. I solve this problem like that: 1. copy old generated doctine models classes to other folder 2… >>> More
(Doctrine-Ubuntu) Get error: doctrine-cli.php: command not found

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, (Doctrine-Ubuntu) I run $ doctrine-cli.php command and get doctrine-cli.php: command not found. P >>> More
Doctrine 2 Cannot find entites

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Kohana 3 and have a /doctrine/Entites folder with my entities inside. When executing the code $product = Doctrine::em()->find('Entities\Product', 1); in my controller, I get the error class_parents(): Class Entities\Product does not exist and could not be loaded Below is the Controller… >>> More
php doctrine last identifier issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running in to the issue below when trying to run the following: $store = new Store(); $store->url =$this->form_validation->set_value('website'); $store->save(); $store_id = $store->identifier(); Fatal error: Uncaught exception 'Doctrine_Connection_Exception' with message 'Couldn't… >>> More

Related posts about php

Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
Apache configurations for php "AddType text/html php" or "AddType application/x-httpd-php php .php"

as seen on Server Fault - Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings: AddType text/html php Although it works, but my understanding is that it should set as following: AddType application/x-httpd-php php .php What are the key differences between the two settings?… >>> More
mod_rewrite settings causes server to throw HTTP 500 errors instead of 404

as seen on Server Fault - Search for 'Server Fault'
Hello. I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows: RewriteEngine on RewriteCond %{HTTP_HOST} ^gsmforum\.ru RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L] # If you are having problems or are using VirtualDocumentRoot… >>> More
Problems installing Memcache (PECL extension)

as seen on Server Fault - Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this: downloading memcache-2.2.6.tgz ... Starting to download memcache-2.2.6.tgz (35,957 bytes) ..........done: 35,957 bytes 11 source files, building running:… >>> More