2008/8/20 Amit Badkas <[EMAIL PROTECTED]>
>
>
> 2008/8/20 bitkidoku <[EMAIL PROTECTED]>
>
>>
>> Hello everyone,
>>
>> I am using CakePHP to build an application that will run on en
>> existing database. The problem I am facing is simple, I have products
>> table and let's say it is like this: id, name, supplier
>>
>> Some stupid programmer (yes I am angry to him) didn't created the
>> table with supplier_id. So every time a product is being added
>> supplier field must be entered manually. This is not my problem. What
>> I want to do is to retrieve all the unique supplier names.
>
>
> - To get unique suppliers, run query, SELECT DISTINCT supplier FROM
> products
>
- Or using cake, $this->Production->find('all', array('fields' => 'DISTINCT
supplier'));
>
>
>
>>
>> I tried:
>>
>> $this->Product->find(
>> 'all',
>> array(
>> 'fields' => array('Product.supplier'),
>> 'group' => 'Product.supplier'
>> )
>> );
>>
>> It does not work. When I query the database manually using "SELECT
>> supplier FROM table GROUP BY supplier" it works.
>>
>> Thank you very much for your answers.
>>
>
--
Amit
http://amitrb.wordpress.com/
http://coppermine-gallery.net/
http://cheesecake-photoblog.org/
http://www.sanisoft.com/blog/author/amitbadkas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
