Questions tagged as 'mysql'

Tagged questions
1
answer

error query php sql phpmyadmin in data type SET, does not return the data correctly (write error)

I have a conculta to my database function ticketsanulacionpendientesSISTEMAS($conexion){ $pendientes = (mysqli_query($conexion, "SELECT COUNT(*) AS conteo FROM ticket WHERE tipo_solicitud = 1 && status = 1 or status= 2 or stat...
asked by 19.04.2018 / 17:18
2
answers

Jquery returns empty values

I have this jquery code in which I assign the values obtained in txtVlr and txtQuantity to some variables, then multilink them and the result put it in the txtSubtotal just when there is a change in the txtquantity, but when executing it the var...
asked by 21.04.2018 / 17:40
1
answer

Group repeated fields of a MySQL query with PHP

I have an intermediate table (N: M) in MySQL where I store the idProfesor and idMateria , when recovering the data from PHP it returns me 5 rows: id | idMateria | idProfesor ---+-----------+----------- 1 | 1 | 1 2 | 2...
asked by 12.12.2017 / 05:27
1
answer

Fatal error: Call to a member function diff () on string in

I want to see the difference of days between the current date and the input data, but I get this error.    Fatal error: Call to a member function diff () on string in This is the code: <input type="date" class="datapicker" required="...
asked by 15.01.2018 / 15:33
3
answers

separate data from a mysql php field

I have this query in mysql that generates a print screen with a number <?php $contratos_query = tep_db_query("select * from " . TABLE_CONTRATOS . ""); $contratos = tep_db_fetch_array($contratos_query);?> The screen shows the...
asked by 18.01.2018 / 15:04
1
answer

I can not find the error parse error [closed]

I have the following code in php: <?php include ("conex.php"); if ($_SERVER["REQUEST_METHOD"] == "POST"){ $centro = mysqli_real_escape_string($con,$_POST['centro']); $descripcion = mysqli_real_escape_string($con,$_POST['descripcion'...
asked by 29.01.2018 / 03:25
2
answers

insert an apostrophe before a query to excel

I have this result of a query $consulta .= '<td>' . $v . '</td>'; where the variable ' . $v . ' is a number that contains leading zeros, so that excel recognizes that number in text format, I must add an apostrophe 'befor...
asked by 31.08.2017 / 15:46
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
1
answer

How to verify field in MYSQL before doing UPDATE [closed]

I have a question ... I'm doing a service order system and the customer is given a secret PIN When the technician arrives, he must request the pin to change the status of the PENDING order to IN PROCESS. The PIN is in MYSQL How can I ch...
asked by 12.02.2018 / 09:57
1
answer

Syntax error Mysql in J2EE Web application Servlets and JSP's

I am building a small web app using NetBeans 8.2 with J2EE. At the moment of executing the following query in the DAO, it shows me a MySQL syntax error that does not exist since if I execute the query in the BD manager there is no syntax prob...
asked by 23.10.2017 / 13:40