Re: ordering by count

Konstantin Saveljev wrote: Hi, i have a system that has media files ==> users can be fans of media ( so media becomes their favorite ). the table itself: CREATE TABLE media_fans( id int(11) unsigned not null auto_increment, user_id int(11) unsigned not null, media_id int(11) unsigned not

ordering by count

Hi, i have a system that has media files ==> users can be fans of media ( so media becomes their favorite ). the table itself: CREATE TABLE media_fans( id int(11) unsigned not null auto_increment, user_id int(11) unsigned not null, media_id int(11) unsigned not null, primary key(id),