Database query

[Guest]

I notice in some websites they include the quantity of products available ie:
in a property site - houses currently available in London :21 and this alters
to 22 as a new property is added to the database. Obviously this is simple
database programming by adding up a column and adding it to your web page but
it seems beyond me to find the answer - can you help?

 

[Jon Spivey]

Hi
This would be a custom query along the lines of

SELECT Town, COUNT(TOWN) AS NumberOfHouses
FROM Property
GROUP BY Town

This will give you results such as
Town NumberOfHouses
London 15
Bristol 17
etc