selecting info on data (meta data)

[sweeny500]

Hi I have a table as follows

CREATE TABLE `res3` (
`rec` INT NOT NULL AUTO_INCREMENT ,
`proptype` VARCHAR( 30 ) NOT NULL ,
`address` VARCHAR( 70 ) NOT NULL ,
`salelet` VARCHAR( 30 ) NOT NULL ,
`town` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( `rec` ) 
)
INSERT INTO `res3` ( `rec` , `proptype` , `address` , `salelet`, `town` ) 
VALUES (
'', 'House for Sale', '2 Riverside Drive', 'for sale', 'Margate'
);
INSERT INTO `res3` ( `rec` , `proptype` , `address` , `salelet`, `town` ) 
VALUES (
'', 'House for Sale', '2 Riverside Drive', 'for sale or rent','Brixton'
);
INSERT INTO `res3` ( `rec` , `proptype` , `address` , `salelet`, `town` ) 
VALUES (
'', 'House for Sale', '17 Perl Street', 'for sale', 'Margate'
);
INSERT INTO `res3` ( `rec` , `proptype` , `address` , `salelet`,  `town` ) 
VALUES (
'', 'Land for Sale', '2 Sea View Avenue', 'for sale or rent', 'London'
);
INSERT INTO `res3` ( `rec` , `proptype` , `address` , `salelet`, `town` ) 
VALUES (
'', 'Duplex for Rent', '44 Angel Crescent', 'for sale or rent', 'Oxford'
);
INSERT INTO `res3` ( `rec` , `proptype` , `address` , `salelet`, `town` ) 
VALUES (
'', 'Duplex for Sale', '17 Link Road', 'for sale', 'Oxford'
);

The data I need to retrieve is to look like this on a web page
House for Sale (4)
Oxford(3) Margate (1)

The problem is that some of the properties are 'for sale or rent'. So in the above example the stats would not be accurate because say a 'House for Rent' may also be 'for sale or rent' So I need a count of how many houses in oxford that are labelled House for Sale but also for sale or rent.
Thanks in advance

[strasm]

You have probably solved this already, but if you haven't here is the skinny. If you are just starting development on this site do yourself a favor and make two different fields for rent and sale. If you are beyond that point I will show a work around.

you can do two seperate count queries like this:

SELECT COUNT(salelet) AS salecount FROM res3 WHERE salelet LIKE '%sale%';

and

SELECT COUNT(salelet) AS rentcount FROM res3 WHERE salelet LIKE '%rent%';

Hope that helps