Posts by V. Bevilaqua • 83 points
5 posts
-
1
votes2
answers152
viewsA: How to generate multiple columns in a query from just one column?
You can use CASE to seprar with SUM to add: select tbl_sef.incricao, SUM(case when tbl_sef.cfop < 5000 then tbl_sef.contabil end case) as Entrada, SUM(case when tbl_sef.cfop >= 5000 then…
mysqlanswered V. Bevilaqua 83 -
1
votes2
answers137
viewsA: Number of entries in SQL PHP
You can use mysql_num_rows(). $total = mysql_num_rows($sql); echo "Total: ".$total;
-
2
votes2
answers360
viewsA: Correct way to make a great Inner Join
I believe the condition of the call is missing ON for the INNER JOIN SELECT a.id_caixa, a.nro_caixa, a.auditor, a.observacao, a.data_ini, a.data_fin, a.tipo_caixa, b.nome, c.nome, d.nome, e.nome…
-
1
votes1
answer1223
viewsA: Take bank dates , and "Highlight them" in a Jquery Calendar
For these cases I use the Datepicker Range, as you already use the Datepicker I believe you will not have any problem. Here has a prettier version of him.…
-
0
votes2
answers1162
viewsQ: Control of login attempts by PHP
I need to provide an external access for a small reporting system, however, I do not know how to control login attempts since I will have to validate the access using the user table of a third-party…
phpasked V. Bevilaqua 83