Database query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top