[SOLVED] Query Help

[d_barszczak]

Hi all,

 

I am trying to design some reports for a script that i am developing but im trying to cut down the amount of queries that it uses if i can help it.

 

The following query will show me all the unique urls in my table.

SELECT DISTINCT `url` FROM `hcl_counter`; 

 

What i would like is to do is also display the number of times it appears all in one query getting a result similar to

 

url , Occours

http://www.google.com, 234

http://www.scripts2go.co.uk, 145

 

and so on...

 

I would normally use the first query and then have php cycle through to get me the numbers but i wondered if i could do this with one query.

 

 

All help is much appreciated.

 

[rajivgonsalves]

here you go

 

SELECT count(*) as numberoftime, `url` FROM `hcl_counter` group by `url`;  

[d_barszczak]

Thats great!!!

 

Do you know of any good tutorials or books that would help me with mysql function as i have learned basic queries but dont seem to be able to find anything more advanced.

 

Thanks.

 

[rajivgonsalves]

you can go through the following

 

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html