Please try to make you syntaks like here: select distinct sum (rankid ), vidno from tableName
thank's --------------------------------------- Jontri Pakpahan http://jontriphan.co.nr ----- Original Message ----- From: "Jer" <[EMAIL PROTECTED]> To: "php mysql" <[email protected]> Sent: Tuesday, April 29, 2008 6:55:58 AM (GMT+0700) Asia/Bangkok Subject: [php_mysql] Creating a "most popular" I've got a table that has a record id and a timestamp written to it every time a user lands on the page. The table is structured: rankid (each row gets its own id) vidno (the access_time I'm at a loss as to how to do this? Do I use a SUM() in the query statement? If so, I have no idea how to apply it to the query and remove the multiple rows of each id to display the unique vidno's. [Non-text portions of this message have been removed]
