Posts by Bruno • 45 points
6 posts
-
0
votes2
answers69
viewsQ: Separate Coordinate String in Array with separate Lat Long?
I need to separate a coordinate string lat/long in PHP which are in the format below in an array separating latitude from longitude:…
-
0
votes0
answers50
viewsQ: Make SQL query with subquery using Where with quotes
I’m trying to make a SELECT with a subquery where the field is in the where of subquery is a field of the main table. However, this field needs to be in single quotes and when I do so, mysql…
-
0
votes1
answer45
viewsQ: Toggle Variable within While
My system controls vehicle travel. When the customer inserts a particular trip to a line, this line has two vehicles associated with it. Then he takes the period, for example from 04/02/2019 to…
-
1
votes1
answer112
views -
0
votes1
answer112
views -
1
votes1
answer5100
viewsQ: SELECT SUM MYSQL
I have the following MYSQL query: select v.id,valor_sap,month(dthr_operacao) as mes, fornecedor_nome from viagem v INNER JOIN agente_viagem av ON v.id = av.viagem_id INNER JOIN agente ON…