Hi, I have a table in MySQL with properties in it with fields such as house.roadname & house.propertytype.
When a user searches my database for a road name, i'd like the query to group by house.propertytype and also state how many results per propertytype in brackets (so I assume it passes this value to a php variable?) Lets say the user searches for Windsor Road, I'd like the results to look like this:
Windsor Road (Total 67 Properties)
Detached House (18)
Semi-detached House (38)
Detached Bungalow (9)
Semi-detached Bungalow (2)
Can someone enlighten me on the query as I'm no expert but the theory seems so simple!