Questions tagged as 'mysql'

Tagged questions
1
answer

Insert 3 more days to the current date add Saturday and Sunday

I have this in php mysql $fechaactual = Date("Y-m-d"); tep_db_query( "UPDATE " . TABLE_ENTREGAS . " SET fecha_calidad = DATE_ADD('" . tep_db_input($fechaactual) . "', INTERVAL 3 DAY) WHERE numero_contrato = '" ....
asked by 06.03.2018 / 11:52
2
answers

Error deleting data in phpmyadmin

I am trying to delete a data in a table in phpmyadmin, when I enter the table and I give it to delete, it does not erase the data. If I try Delete as a query from the console I get the following message: 1054 the column in where clause is unk...
asked by 01.06.2018 / 14:53
1
answer

Error in SP MYSQL

I have the following error:    #1064 - Algo está equivocado en su sintax cerca '' en la linea 6 I show code CREATE PROCEDURE spF_detalleVenta_one1(cod int) BEGIN SELECT d.CodigoVenta, d.CodigoProducto, p.Nombre, d.Cantidad, d.Des...
asked by 31.05.2018 / 00:21
1
answer

How can I go through all the records of two queries at the same time

How could I loop through all the records of 2 queries (at the same time) that are stored in 2 associative arrays (mysql_fecth_assoc) and compare them with the function array_diff (array1, array2). I did it this way and only loads (and compare...
asked by 01.06.2018 / 11:43
2
answers

Console error when sending form data using Ajax

Friends please I need help I do not know why ajax does not bring me the result of the request when I send data from my form. If someone at least explain to me what is my mistake and what is it about? Thanks. What I know, is that when I send m...
asked by 16.07.2018 / 05:06
1
answer

Create two Delete triggers, in the same table

I currently have a disparador that updates when I delete a data from the table pago_detalles update pagos a join pago_detalles di on di.idpago = a.id set a.pagado = a.pagado - di.monto but do not let me create...
asked by 16.07.2018 / 19:09
1
answer

Jquery dependent values in several rows

I have a button that adds, on the one hand, a row in a table with fields to fill. Also, with the same button, a row is added to another table, where some dependent data of the first table is completed. The problem is that when you add two rows o...
asked by 05.04.2018 / 20:09
1
answer

What is the reason for this error in Ajax?

I'm working with ajax but I get this error and I do not know why it happens when I add an image to my ajax     
asked by 26.02.2018 / 01:13
1
answer

MySQL Foreign Keys

I have a problem when I try to create a table with two "foreign key", I have a user table: CREATE TABLE IF NOT EXISTS usuario ( id int(4) NOT NULL AUTO_INCREMENT, email varchar(20) NOT NULL, nombre varchar(20) NOT NULL, contrasena varc...
asked by 25.02.2018 / 19:10
1
answer

How to make a search engine that searches in multiple columns?

I'm working on a project with phonegap, so I work in javascript, html and css environment and working this data externally with PHP and MYSQL. I have a search engine made by ajax and that everything is perfect, it shows me what I'm looking for c...
asked by 26.02.2018 / 14:18