Questions tagged as 'mysql'

Tagged questions
2
answers

Search between dates JDateChoser java mysql

I get the following error:    you have an error in your sql syntax check the manual that corresponds   to your mariadb server version for right syntax to use near INNER JOIN   medication ON detail_compra.idMedicamento = medicamento.idMedicame...
asked by 06.08.2017 / 08:25
3
answers

Error Code: 1215. Can not add foreign key constraint

I try to create a couple of tables in MySQL, this is the sentence to create the first one: ----- Creamos la Tabla de Usuarios del Sistema Create table if not exists USUARIO ( ID_USUARIO BIGINT UNSIGNED not null auto_increment comment 'Id...
asked by 06.07.2017 / 06:35
1
answer

ORDER BY in PHP that does not ORDER nothing at all

I have a query in mysql When I do it through PHP, I simply ignore the ordering as I need it (whatever field I try to order it from). The problem is in PHP that's why I pass the code that I have to call that query: $diaActual = date("Y-m-...
asked by 11.07.2017 / 15:45
2
answers

Help with getting the id of a PHP / MYSQL form

Good I have a problem to obtain the id of a form: I have in my database a table called assistances which I want to edit an observation by form whenever I want. in my list I have: <html> <head> <body> <?php inclu...
asked by 10.07.2017 / 22:46
1
answer

Does not validate conditional with array in php

I have a form that adds the total amount of all the installments. I put a conditional where it tells me if the array has data print me the total otherwise I print a message. I do not know what my error is, but it does not print the message. I...
asked by 06.07.2017 / 17:56
2
answers

Fill table with Select mysql

Good afternoon, I need to fill a datatable of jquery with the data brought from a select with the filter of a parameter, select the filter from a checkbox and pressing a button displays the data in the table The query works, but when showing the...
asked by 06.07.2017 / 20:51
4
answers

count of 2 tables in mysql

I have 3 tables in mysql, one is customer, another store and reserve, this is related to the customer table and steals the id and the store tbl and also steals your id, my question is, how can I make a list of all the clients and know how many r...
asked by 08.07.2017 / 00:51
1
answer

Use subqueries or joins? Alternatives to left | right join? [duplicate]

Good morning. My Doubt is: Which is better in terms of readability and performance, use subqueries whenever possible or use the "join" format? What is more important, readability or performance? I would understand that many would say that if t...
asked by 15.07.2017 / 00:17
1
answer

Problem when making a record in the database

Good, I have uploaded all the files to a free server, they are the databases, I have tried the files without problem via local with wamserver , but already uploads this problem when inserting data .    Warning: mysql_select_db () expects par...
asked by 27.06.2017 / 04:21
2
answers

Group records in a table

I have the following query: SELECT * FROM tabla1; So it shows this: Empresa | Empleado -------- --------- pepsi | jose -------- --------- pepsi | pedro -------- --------- pepsi | juan What I want you to show is this: Empresa |...
asked by 12.06.2017 / 15:02