Questions tagged as 'mysql'

Tagged questions
1
answer

Dates Comparison

Friends, I have a problem with my program. It turns out that in my database (mysql) I indicate the days and hours in which an entered task will be executed. And through a php process I'm running the processes that meet that condition and there's...
asked by 04.06.2018 / 18:33
1
answer

MySql statement is not executed in php function

Friends I'm new to php .. I have a mysql statement that does not give me a php function, I execute it in mysql and if it executes me in the function it does not. Also the data arrives at the function and all I do not do is run the mysql semtenci...
asked by 04.06.2018 / 21:37
1
answer

error when saving in a vector the values of a Select

I am trying to save the values of a Select in a vector, but the error appears java.lang.ArrayIndexOutOfBoundsException: 0> = 0     
asked by 16.06.2018 / 07:40
1
answer

Group query without losing different records

I need help making the following query: From the permissions table, obtain the user's row without losing data from the action and value column. Greetings,.     
asked by 06.06.2018 / 15:18
1
answer

ERRORSQLSTATE [23000]: Integrity constraint violation: 1048 Column 'url' can not be null

When executing the query, I get the following error:    Notice: Undefined index: text in C: \ xampp \ htdocs \ Dreasity \ views \ new-publication.php on line 14   ERRORSQLSTATE [23000]: Integrity constraint violation: 1048 Column   'url' can...
asked by 14.07.2018 / 06:46
1
answer

Instant search through an input with autocomplete (select)

I have a little problem with a part of the code. I try to do an instantaneous search that when entering data (registration) through an input, show (as verification) that the registration exists and show the name of the person who has that reg...
asked by 13.07.2018 / 20:34
1
answer

Unexpected result in a statement when using ALL

I have created the following tables: productstest orders The query is as follows: SELECT nombre FROM productostest WHERE id = ALL (SELECT idProducto FROM pedidos WHERE cantidad > 0); This query does not return an...
asked by 09.06.2018 / 14:58
3
answers

print variable with quotes in another php file

Friends, I have a problem with the "... really a headache, I have a php that writes another php code, something like this: Php1 writes content in a file called file and file must execute a mysql statement with the value of a variable that was in...
asked by 01.06.2018 / 19:48
3
answers

Obtain the individual total by registration

I have the following tables: REPORTEBETEITIVA _______________________________________________________ | idReporteBeteitiva | HorasTrabajo |Trabajador | ------------------------------------------------------- |...
asked by 06.06.2018 / 15:29
2
answers

Problem to update record with php and mysql combobox?

I'm doing the update of a record in my BD by <select> but it does not work for me. monitoringService.php <html> <head> <form method="POST" action="actualizarSeguimiento.php"> <label>Situacion: <...
asked by 08.06.2018 / 20:02