Questions tagged as 'mysql'

Tagged questions
1
answer

Get Different records from a single table in a Multiple query

Good morning everyone. I come to you asking for your advice about how I can make a sentence (if possible only one). The situation is as follows, in my database I have 4 tables from which I need to extract information for a report that has...
asked by 24.04.2018 / 15:31
0
answers

Unknown system variable 'TRANSACTION'

   Error occurred during script startup, usually a result of inability to connect to the database:       Error triggered: Unknown system variable 'TRANSACTION'.       This was probably caused by a software bug. If these occur often try to en...
asked by 22.04.2018 / 19:59
1
answer

Start query mysql in imput text when it is active and reference it if id

I'm still trying to perfect my form with the auto-completion feature. The code I have so far works through the keydown option and would need to start the query to mysql when the user of the focus to the imput text that is assigned to the quer...
asked by 29.04.2018 / 22:12
0
answers

MYSQL - UPDATE to two tables

hi friends (as) along with greeting them came to ask for your guidance (again), I have 2 tables that have a field in common: id_estado. What I have to do is update this field in both tables simultaneously, since this id then shows the field in a...
asked by 29.04.2018 / 22:01
1
answer

Show results from a query to three tables with INNER JOIN

I have a problem may be easier than I think but it really takes me several nights and I could not solve, the thing is that I have three related tables and I want to make a query that brings me data from each of them, I have the following tables,...
asked by 29.04.2018 / 19:21
2
answers

Problem with inner join sql

I'm going crazy, I've tried several databases and it does not work to see if you can help me. select 'Tienda.Codigo_de_barras' from "Tienda" inner join "Online" on 'Tienda.Codigo_de_barras' ='Online.Codigo_de_barras'; The code consists of...
asked by 21.04.2018 / 17:48
1
answer

Error: mysqli_num_rows () expects parameter 1 to be mysqli_result

I have a problem with a query in php and mysql, I do not know why it shows the following error in two lines of my code, it shows it in line 35 and line 45:    Warning: mysqli_num_rows () expects parameter 1 to be mysqli_result,   boolean give...
asked by 20.03.2018 / 21:33
0
answers

Mysql AND operator problem in PHP

I have this query that works perfectly in MySQL: select maestro from destajosetapas WHERE idetapa = '18' AND iddestajo='15241' By collecting the results PHP gives me NULL , but if I put: select maestro from destajosetapas WHERE idet...
asked by 19.04.2018 / 21:00
1
answer

You do not have permission to access / phpmyadmin on this server

I have a server mounted on a centos 7 machine and a dynamic dns to which I can access remotely, but when I try to enter the database that I have on that server using php my admin, I get this. Search the internet and I have to modify the...
asked by 24.04.2018 / 05:49
0
answers

PDO - Insert does not save the data, but I do not have any errors in the php

I have to save some data from a form in a mysql database. In a php file I have a select (combobox) that is filled with values from tables in the database. I think I have the insert code well, but for some reason it does not save anything....
asked by 19.04.2018 / 16:43