Questions tagged as 'query'

Tagged questions
1
answer

Invalid parameter number: parameter was not defined in PDO PHP

Good day community, I have this problem when wanting to save data in my database, I am creating a SignUp, but since adding "FDia", "FMes" and "Fño" to my form and it is stored by PHP , throw me that error, and investigate other related qu...
asked by 27.01.2018 / 21:25
4
answers

How to get repeated records in mysql?

I have this table +------+----------------+-----------------+ | id | home_team_name | visit_team_name | +------+----------------+-----------------+ | 1436 | Philadelphia | Miami | | 1431 | Jacksonville | Carolina | | 142...
asked by 25.08.2017 / 20:46
3
answers

Help with this sql query

I have a question with the following exercise: Aware of the extra expenses that employees must face in the month of March, it is desired to reward the employee or employees with the highest sales amount for the month of March. To do this, we...
asked by 06.04.2017 / 00:38
1
answer

Data from two tables in the same query

I need to show the matching records of two tables, sorted by date. I can show them in the way I show in my code, but of course, first show the data of one table and then the other. I think the necessary thing is to join the two consultations, bu...
asked by 25.11.2018 / 17:34
2
answers

Error in php query

I have the following code that should print me the amount of products registered in a table <?php require_once "js/conexion.php"; $sql = 'select count(idp) as total from producto'; $result = $mysqli->query($sql); if(!$r...
asked by 01.11.2018 / 06:42
1
answer

Problems with fetch () fetch_array ()

I'm having problems with fetch() fetch_array() I'm working with sentences prepared since yesterday I'm new to it and I have this code that practically doing fetch() is not throwing me anything I do not know what I'm doing wr...
asked by 25.08.2018 / 22:13
1
answer

Inner Join of Queries

I comment, I have a query that has a query that brings me certain users under certain conditions, and I have another query with other idusuarios submitted to other conditions, so I would have CONSULTA 1: XXX idusuarios CONSULTA 2: XXX i...
asked by 03.09.2018 / 21:43
2
answers

How to filter the last entry registered by your user id - Django

Hello friends, I'm new to django. I would like to make a query to update the number field. What I want to do is filter by the user and filter by the last entry of that user, and then update the number field. The querysets I know are the fo...
asked by 23.08.2018 / 06:42
2
answers

Problems joining two sql tables and comparing if there is

I want to get a query where Cve, Name and Exist, in one table I have the catalago and in another I have the ones that exist, therefore I want to get all the catalago but with an extra field that is in 1 those that exist and in 0 those that are...
asked by 23.06.2018 / 20:23
1
answer

Join Query in one with JOIN [closed]

I'm trying to merge several SQL statements into one, the problem is that it has a JOIN and I do not know how to rename tables SELECT users.nombre,users.apellido,users.id, COUNT(ligauruguaya_v.primero) AS Primero FROM users LEFT JOIN ligaur...
asked by 24.03.2018 / 18:08