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?
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?