Hi! Now a newbie question ...
I need to know how many times a web page on my site has been visited.
This data is stored in a table called stats.
Then, my query is:
select visited_url, count(*) from stats group by visited_url
That's ok, but the results are not sorted ...
I have tried this query, too:
select visited_url, count(*) from stats group by visited_url order by count(*) desc;
but i got errors!
Can anyone help me?? Thankyou.
I need to know how many times a web page on my site has been visited.
This data is stored in a table called stats.
Then, my query is:
select visited_url, count(*) from stats group by visited_url
That's ok, but the results are not sorted ...
I have tried this query, too:
select visited_url, count(*) from stats group by visited_url order by count(*) desc;
but i got errors!
Can anyone help me?? Thankyou.