By sander_cassiers on

How can i show the max values from a dynamic query?

$query = db_select('data', 'n')
->fields('n', array('field1, max(field2)))

->groupBy('field1')
->execute();

this doens't work

⋅ Categories: Drupal 7.x

Comments

arrakis83’s picture

arrakis83 commented

This two posts may help you :
http://drupal.stackexchange.com/questions/9540/add-a-max-aggregation-fun...
http://drupal.org/node/1113158

sander_cassiers’s picture

sander_cassiers commented

Hey, it is fixed.. the type from the database was set on 'VARCHAR'.
so there could not be a max value for it..
I changed it to integer, and it works just fine.