Hi, thanks for that. It worked. but i decided I wanted the title to show up. So i put into my index.php thing and made a querie but it wont show up the title of the winning group at all.
$totalpoint=$DB_site->query_first('SELECT user.membergroupids,max(points) AS tt FROM user WHERE user.membergroupids GROUP BY user.membergroupids');
$totalx=$totalpoint[user.membergroupids];
$total=$DB_site->query_first('SELECT usergroup.title FROM usergroup WHERE usergroup.usergroupid="$totalpoint"');
$totalz=$total[usergroup.title];
any help?
|