Hello,
I'm working on WHERE conditions field in CCv4
my goal is to select only the max ID for each user_id
(user_id works) (but MAX ID not)
but it cause sintax error....any idea on how to solve?
Many thanks🙂
I'm working on WHERE conditions field in CCv4
my goal is to select only the max ID for each user_id
(user_id works) (but MAX ID not)
<?php
$user = JFactory::getUser();
return array('testresults.user_id' => $user->id );
return array('testresults.id' => SELECT MAX('id');
?>
but it cause sintax error....any idea on how to solve?
Many thanks🙂