Questions tagged as 'mysql'

Tagged questions
1
answer

Error in a trigger to erase rows

I have the following trigger: CREATE TRIGGER actualizarConsulta AFTER INSERT ON ranking FOR EACH ROW BEGIN DELETE FROM Consulta C WHERE C.jugador_id = NEW.player_id; END; When I try to execute it I get the following er...
asked by 28.04.2018 / 15:36
1
answer

How to display data from a query by specifying the records in java [closed]

What I want is that when you select the client of the table you will be shown all the purchases made by that client in a table and that when you search for a date, for example, only the records of that client appear and not of all     
asked by 26.04.2018 / 19:26
2
answers

Edit rows with php

I just make a table of users with the functions of delete, edit and add, I have the functions of adding, deleting and editing, the problem is when I give edit to a row I see the fields in the row with the id = 1, this in any row, and what I want...
asked by 26.04.2018 / 14:50
1
answer

Ajax-Error using Json in PHP

I'm using Json to make an insert in MySQL using ajax, but I do not get any results and the insertion is not done, what am I doing wrong? JS code $("#btnprueba").click(function () { var array1 = []; $("#tabla .DataRow...
asked by 30.04.2018 / 04:21
1
answer

Show new BD field in cakephp view

Well the problem is as follows, create a field in the database @KacosPro and connect a page to make an ibdate in this. The thing is that now I must connect it from another page that shows a table, the thing is that it does not do anythi...
asked by 24.04.2018 / 15:57
1
answer

Insert in a Mysql table which in turn depends on two other tables

I'm trying to insert into a table called badges_members which in turn depends on two additional tables, one is called badges and the other members . The badges_members table has the following structure: And I am trying to insert...
asked by 23.04.2018 / 17:45
2
answers

Bring an id from another sql table

I am working with php and I need to point to the id of a detail table, the problem is that I show information from the main table but my button must point to the table information here my problem: The id of the main table is 168 but...
asked by 20.04.2018 / 21:25
1
answer

how to insert the value of a select into multiple columns of a table in MYSQL PHP

good day, I hope you can support me with this query, How can I insert the value of a select (combobox) php in multiple columns in a table in mysql depending on the selected data? . For example I have this form linked to nested combobox with...
asked by 14.05.2018 / 15:41
2
answers

List MySQL Data in PHP

I have a list of names, emails and messages that I want to show, my problem is that when you show it, only the first of the records is displayed and it is repeated many times. I attach the code: <?php //Conectar con el servidor $link=mys...
asked by 29.05.2018 / 21:13
2
answers

Retrieve select input value

I have the following piece of code that allows me to store new information in a MySQL database and also allows me to recover the saved information and make a modification if I wish. <input class="input_mayuscula" type="text" name="sistema_e...
asked by 19.06.2018 / 10:39