populer books query?

[Sinan Eldem]

CREATE TABLE `populer_books`
( `id` bigint(22) NOT NULL auto_increment,
`books` int(11) default NULL,
`user` int(11) default NULL,
`editor` int(11) default NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`))
ENGINE=MyISAM;

this is mysql table structure

i want to list the books which are added to this table at list 10 times by users. will you please help me with the mysql query?

thanks...

Sinan Eldem
www.sineld.info
www.siirevim.com



Edited 1 time(s). Last edit at 09/27/2005 10:48AM by Sinan Eldem.