[perleo]

How do I select the most popular piece of data in an MySQL table?

How would the select statement go ??

Also, if i have times in an row in the db, how would i add alll the time in the table ?

[NeverMind]

Originally Posted by perleo

How do I select the most popular piece of data in an MySQL table?

How would the select statement go ??

Also, if i have times in an row in the db, how would i add alll the time in the table ?

what do you mean by 'most popular' ? you mean most visited/viewed ?
if so , you need to add a counter to the table structure and then UPDATE it with something like that :

Code:

UPDATE table SET counter=counter+1;

to fetch the most visited/viewed/popular :

Code:

SELECT item, whatever, counter FROM table ORDER BY counter LIMIT 1;

and last part about time is not clear ..