Good evening, I'm creating an indication system,
But the query result does not return users with zero statements
Here's my select
SELECT
c.id,
c.nome,
funcao,
area,
count(p.cpf_cli) AS quantidade
FROM col c
LEFT JOIN...
I want to pick up the items that are smaller than the current date and time, but when I run select it gives the error message, not a valid month. In the database the date is set as follows, '25 / 09/18 10:23 '.
SELECT * FROM v_tpl_acompanhamen...
I'm having difficulty using MySQL.
I've been asking here already, and I've done a lot of testing and progress in crafting a select for a ranking .
I have a "player" table that holds among other infos, nome_jogador and pontuacao...
I'm having trouble getting a cumulative count in mysql. I need to count the amount of active registration accumulated in each month.
Table:
id | data_cadastro | data_exclusao
---+---------------+--------------
1 | 2018-07-01 | null
2 |...
I'm building a search system using Mysql and PHP, with a form in the _GET method.
I wanted to put together a system that if the person types the wrong one, the site can "correct" the word, or suggest the correct word.
The only way I though...
Someone can help me with this code.
Give this error:
Warning: mysql_fetch_array () expects parameter 1 to be resource, boolean given in /var/www/xxx/teste.php on line 14
Notice: Undefined variable: status in /var/www/santa/teste2.php on...
I'm currently using the jquery table to display the results, but it takes a long time to display all the results and while the search does not finish the browser sometimes crashes.
have some better way of showing results but without crashing you...
I would like to know how to update a select with data coming from another.
I currently use SQL, I already have a connection created:
$connection = new COM("ADODB.Connection"); //instancia a classe de conexao
$connection->Open("PRO...
How do I change and save in the database, as soon as I update the saved value in the box, the way I am saving in the database, but when updating the page it leaves the box always filled with the first value.
$ifs = "SELECT * FROM config WHE...