I found a trick using "GROUP BY" instead of "ORDER BY" but maybe someone need an answer to the question too :)
You can do the following
$option = Option::all(array('select' => 'DISTINCT *', 'joins' => $join));
Giacomo
Here is an ORM that works with MySQL
https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx
I think OP wanted a finder that could be added to the model subclass. I do. Thinking it's relevant....
I have to use an externally defined schema where a descriptive attribute is non-normalized. Call it Book.Category. Category is a string but no other constraint. I can use your example, but what I really need is to be able to define Book extends Model
find_distinct_categories()
such that I don't have to replicate that SQL throughout my code. I've looked at dynamic finders but they don't appear to support select criteria like distinct. TIA!
(1-4/4)
Subject: Add "DISTINCT" to finder
Hi all,
I'm using PHP 5.3 + mySQL 5.1.31 and I'm looking for how to add a "DISTINCT" to a finder, I would get this query:
SELECT DISTINCT * FROM Options JOIN ...
And I'm using this syntax:
$join = 'JOIN Options_per_Orders ON
(Options.`idoption` = Options_per_Orders.`idoption`) JOIN Orders ON
(Options_per_Orders.`idorder` ='.$order[$i]->idorder.' ) ORDER BY category ASC';
$option = Option::all(array('joins' => $join));
Thank you