Zikula Community

• msshams
  
  

  • Rank: Registered User
  • Registered: Dec 02, 2007
  • Last visit: Oct 21, 2009
  • Posts: 40

  Posted: Oct 03, 2011 - 05:54 AM

  Hi there,
  i want to ask you how can i use MAX() function when we use GROUP BY in DBUtil?
  for example did you see News_userapi_getMonthsWithNews() function?
  there we have something like this:
  
  $order = "GROUP BY EXTRACT(YEAR_MONTH FROM $news_column[from]) ORDER BY $news_column[from] DESC";
  $date = DateUtil::getsysDatetime();
  $where = "($news_column[from] < '$date' AND $news_column[published_status] = '0')";
  $dates = DBUtil::selectFieldArray('news', 'from', $where, $order);
  
  in this case, i want to know how can i select MAX(from)?
  i need to select 2011-07-20 between 2011-07-18 and 2011-07-19 and 2011-07-20.
  
  thank you

  • 
  •  
• rgasch
  
  

  • Rank: Team Member
  • Registered: Jan 05, 2003
  • Last visit: May 28, 2010
  • Posts: 776

  Posted: Oct 03, 2011 - 03:01 PM

  Hi,
  
  for this you need to manually execute SQL and pass a column array (ie: the names of the columns of your result). Something like this:
  
  

  Code

  $sql              = 'SELECT blah blah blah ... ';
  $columns          = array('maxvalue');
  $res              = DBUtil::executeSQL ($sql);
  $counts           = DBUtil::marshallObjects ($res, $columns);

  
  
  Greetings
  Robert

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.