Posts by Alexandre Vieira • 73 points
7 posts
-
1
votes5
answers79
viewsA: SQL using two tables
Try it this way. SELECT * FROM solicitacoes_solicitacao ss LEFT JOIN solicitacoes_tarefas st ON st.id_solicitacao = ss.id WHERE ss.dataconclusao != '0000-00-00' AND ss.dataconclusao IS NOT NULL…
-
1
votes2
answers109
viewsA: PHP Storm - spaces
Thanks @marcos-Padilha . I did not find this option in windws, but using the same reasoning found this outa.…
-
-2
votes2
answers109
viewsQ: PHP Storm - spaces
Does anyone know why PHP Storm is automatically correcting excess space?…
-
0
votes1
answer715
viewsQ: TXT file on android
How do I write a TXT file to android using Delphi 10 Seatle? I’ve tried that way and only from mistake; try file1 :=…
-
1
votes1
answer406
viewsQ: Access website on SMARTTV
Hello, I developed a web system in php/html/css(Bootstrap) and open normal on various devices pc, notebooks, tablets, cell phones but on TV’s Smart, which is the focus of the system, it did not look…
-
1
votes0
answers39
viewsQ: Engagement of system users
We have a Helpdesk system, and we’re developing a FAQ, my question is how do I get more engagement from users. Ex: Here in stackoverflow if you use achievements, score would like something similar.…
phpasked Alexandre Vieira 73 -
2
votes2
answers587
viewsQ: Sort by the result of the sum of two SUM - MYSQL
I need to order a query by the result of the sum of two sums. ORDER BY SUM(SUM() + SUM()) I tried the following: SELECT SUM(campo1 + campo2) AS soma1 , SUM(campo3 + campo4) AS soma2 , SUM(soma1 +…