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
|