好的,所以我需要张贴前3个业务类别与顶部的搜索。我试过网上提供的建议:
$sql = "select search, city, business, count(*)
from vendor
group by category = 'Beauty Salon'
order by count(*) desc
fetch first 3 rows only";
我试过:
$sql = "SELECT search, city, business,
COUNT(*) AS total FROM vendor
WHERE category = 'Be