Posts by Marcelo Henrique Casali • 61 points
6 posts
-
0
votes1
answer131
viewsA: Cities with the same name using Geocharts
Solved, I used a Concat(municipios.nome,' ,) in the PHP file that generated the json. Geocharts recognizes cities with the same name, saying what state it is from. Example Maceió AL…
-
0
votes1
answer131
viewsQ: Cities with the same name using Geocharts
I’m doing a project, using Geocharts, as I’m working all the municipalities throughout Brazil, there are some cities with the same name, when I show these cities, they appear in the wrong state, has…
-
0
votes1
answer94
viewsA: Problems in Mysql query
Problem solved: SELECT sum(populacao.quantidade), estados.nome, (SELECT sum(internacao.quantidade) from estados as est inner join municipios as mun on (est.idEstado = mun.idEstado) inner join…
-
2
votes1
answer94
viewsQ: Problems in Mysql query
I’m having difficulty in performing a query between 4 tables, being them. States > Municipalities > Deaths > Population The query is returning the value of the population with a larger…
-
2
votes3
answers4951
viewsA: Json PHP and Mysql
Amigo, I did it!! The final code was... Thanks if ($result = mysqli_query($con, $sql)) { while($row = $result->fetch_object()) { foreach($row as $key => $col){ $col_array[$key] =…
-
2
votes3
answers4951
viewsQ: Json PHP and Mysql
I am working in a personal project with an open database, and I need a JSON file from a MYSQL query, I am a few days trying to solve this problem and I am very difficult, because I can not get the…