Zend_Db_table , DISTINCT

Tommy1402 · #1 (**permalink**) 03-05-2007, 03:55 AM

Hi,
How to make a DISTINCT selection from a table?
from table below, I select all data from table ITEM, in table item, there are some records which have same name.

PHP Code:


			
$myItem = new Item();

$view->item = $myItem->fetchAll();

can I use something like:

PHP Code:


			
$view->item = $myItem->fetchAll('DISTINCT');

?

I can use DISTINCT mode when I use the DB object instead of Table object, like:

PHP Code:


			
$sql = "SELECT `itemid` DISTINCT FROM `item`";

$view->item = $db->query($sql);

But, if I use the DB object, what's the point in creating model of table ITEM ?

Thanks!

Cristian · #2 (**permalink**) 03-05-2007, 07:40 PM

What adapter are you using ? PDO_Mysql ?

Tommy1402 · #3 (**permalink**) 03-06-2007, 07:44 AM

Yes, I use PDO_MySQL

OldStyle · #4 (**permalink**) 09-13-2007, 02:47 PM

I am also trying to get Zend Db Table to execute a Distinct Select. Dosent appear like that is currently an option.

RiotRick · #5 (**permalink**) 10-01-2007, 01:46 PM

I'm trying the same thing. Their doesn't appear to be an option for this.

Bootle · #6 (**permalink**) 10-01-2007, 11:09 PM

From the documentation:

Quote:

10.4.3.10. Adding the DISTINCT Query Modifier

The distinct() method enables you to add the DISTINCT keyword to your SQL query.

Example 10.63. Example of the distinct() method

<?php

// Build this query:
// SELECT DISTINCT p."product_name"
// FROM "products" AS p

$select = $db->select()
->distinct()
->from(array('p' => 'products'), 'product_name');

10.4.3.11. Adding the FOR UPDATE Query Modifier

The forUpdate() method enables you to add the FOR UPDATE modifier to your SQL query

Zend Framework: Documentation

Doesn't seem like you can execute it from a model though...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode