MySQL functions question... [Solved]
Posted: Sun Nov 20, 2005 7:00 am
Hi,
I have a table called 'Properties'. The 'Clicks' column records how many hits on my site the property has acquired. The 'LocationID' column records the locationID of each property.
I want an SQL query that will return the top 5 locations by total clicks for properties in that location (locationID). Can anyone suggest a query that will do this, without having to use intermediate PHP code?
Many thanks
Mark
I have a table called 'Properties'. The 'Clicks' column records how many hits on my site the property has acquired. The 'LocationID' column records the locationID of each property.
I want an SQL query that will return the top 5 locations by total clicks for properties in that location (locationID). Can anyone suggest a query that will do this, without having to use intermediate PHP code?
Many thanks
Mark