User with the highest amount per month for the last 12 months mysql -
i have table:
create table `like` ( `id` int(10) not null auto_increment, `like` tinyint(1) not null default '0', `userid` int(10) not null, `dateline` int(10) not null, `to_userid` int(10) not null primary key (`id`), ) engine=innodb default charset=utf8;
i have list last twelve months, showing to_userid highest sum of like, next month , year.
edit: dateline stored unix time.
can please?
Comments
Post a Comment