I have some checkBox which are a query in DB. I need to get the selected fields and then make a division but it is not working.
<form action="contas1.php" method="POST">
<div class="form-group">...
I wrote 2 possibilities to return the number of results using CodeIgniter, as follows:
public function get_num_indicados($id_usuario)
{
$query = $this->db->query("SELECT count(id_patrocinador) as num FROM usuarios WHERE id_patrocinad...
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 have the following tables:
I need to list COMPANIES and REGISTERS IN THE EVENT (which can have more than one talk) and in the same line bring the QTD OF GIFTS by lecture in columns ... Thus I would get a parameter of use per lecture i...
Has anyone managed to do a row count per group with dataTables?
Considering this structure:
$('#tabela').DataTable({
"lengthChange":false,
"pageLength": 500,
"filter":true,
"responsive":true,...
I'm trying to count the number of occurrences of multiple text patterns in a log file.
My code is counting all the lines in the file for all text patterns.
Where am I going wrong?
The log file looks like this:
Feb 1 00:00:02 bridg...
I'm solving an exercise but I'm having problems with the return:
Question:
Write the query that returns the vendor code, the vendor name, the number of products per vendor, and the average price for each vendor, only for vendors that have a...
I want to show all records in the student table - name and number - and then in the right column, show the percentage of attendance. Let's see:
SELECT nome, numero, (
(
SELECT COUNT(aluno.numero)
FROM aluno
JOIN aula ON aluno.id_aula_aluno =...
I have a script in PHP and MySQL that has a query responsible for counting how many records (clients) are inserted into one of the tables in my database. However, I need to show the amount of records (clients) in the table with the echo command,...
I'm making a system and I have to know which user sent the most messages. My tables look something like this:
User
id|nome|sobrenome|email| ...
Messages
id|uid|nome|email|assunto|msg| ...
I just need to know which user sent more...