I need assistance with using LavaCharts, has anyone used it to get data from multiple tables?
I want to get a report showing count of cities in a particular province.
The cities table has a province_id, so I want to show a geo chart by province with number of cities in that province.
This is the raw sql query that gives me the data from db
SELECT
provinces.`name`,
Count(cities.province_id)
FROM
cities ,
provinces
WHERE
cities.province_id = provinces.id
GROUP BY
provinces.`name`
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire