I'm trying to get the most read article out a table.
The table has a title column, a read column and some others.
So I wanna SELECT the title from the table and the most read figure.
SELECT title, MAX(reads) FROM articles
This only gets the second most read article?! If I take out the title like:
SELECT MAX(reads) FROM articles
Then it gets the top article number but obviously not the title.
Can anyone shed some light?
The InternetOne UK Ltd
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]