PHWinfo - Afficher un message

05/09/2007, 15h17

[snip]
I have a Table and want to know the most visited products.
Products

- Id

- Name

- Visited
[/snip]

SELECT Id, Name, count(Visited) AS Total_Visits FROM product GROUP
BY(Id)

05/09/2007, 15h17	#3
Jay Blanchard Messages: n/a Hébergeur:	RE: Simple questio SQL [snip] I have a Table and want to know the most visited products. Products - Id - Name - Visited [/snip] SELECT Id, Name, count(Visited) AS Total_Visits FROM product GROUP BY(Id)