Max() function in mySQL

admin

Administrator
Staff member
Hi there, I seem to be having a nightmare of a time with a very simply funtion. Quite simply I want my counter to produce the maximum number of hits any section of the site has got.

I've been using the line:

$max_hits = mysql_query("SELECT max(hits) FROM counter");

And all I seem to get is "resource id#21"

There must be a painfully simple answer. This line works when I query the mySQL database directly but not when I'm incorporating into PHP.

Any ideas what I'm doing wrong?
 
Back
Top