Questions tagged as 'mysql'

Tagged questions
0
answers

Count rows in an inverted way in php

I am trying to add the values of a row from bottom to top but I can not do it, I have tried with a for loop with the array_reverse property and with the ORDER BY property but I can not find the correct result. In the array_reverse I invert the v...
asked by 24.06.2018 / 22:59
1
answer

what can I change, when loading an xlsx to excel and if a cell has: 'mark error

good day. I already have the page created and I upload my excel files to mysql using php, all right up there but when cell has the sign of ' There is an error when inserting or updating the table. Excel files send them to me, I adapt them to m...
asked by 23.06.2018 / 03:39
0
answers

Generate dynamic table with PHP MYSQL Doubt

I have been trying to achieve this for some time, but I have not been able to, so I decided to turn to this community. I need to dynamically generate a table like the following image, which must be generated from an Mysql database, for exampl...
asked by 23.06.2018 / 04:20
1
answer

How to relate from many to many in Eloquent (Laravel)

I am using MySQL as a database and Eloquent as ORM. I have been creating a page that is of food or dishes, in which I already have related the meals with the chef that prepare it, so I have them : Table foods (meals) publi...
asked by 16.07.2018 / 19:55
0
answers

When doing LEFT JOIN in MySQL, the data of the SUM () is altered

I have a structure of related tables. The main one is a table called MOVIMIENTO_ALMACEN with its column called CANTIDAD where it calculates the amount but according to the type of movement (" ENTRY " OR " EXIT ") and they make a s...
asked by 16.07.2018 / 21:36
1
answer

Update to one field taking into account two others from a different table

This is the code I am trying to use, with this achievement I make the Update to the field I want but only take into account one of the two fields I want to validate before the Update is made. $sql = "UPDATE ingresos SET cod_factura='$fa...
asked by 26.06.2018 / 12:08
0
answers

list in jsp - several numbers

I have a phone book that has fire departments bodies (body_id, body_name) a table calendar (agenda_id, body_id, address_number) the issue is some fire departments have several phone numbers. I do not know how to do it so that it shows...
asked by 09.07.2018 / 18:08
0
answers

Upload data from MYSQL to PHP Form

Hello, I am preparing a form to load data from a MYSQl database, it is the same data that I enter, I just want that in this form they can be edited, the code I have is: <?php // 1) Conexión if ($conexión = mysql_connect("localhost", "root...
asked by 20.06.2018 / 17:42
0
answers

save radiobutton php and mysql

I have a form to add rows to a table what I do not know how to do is how to receive the radioButton field when saving, since each one has different names in each row, for example 1st row --- SinPendulo0 2nd row ---- SinPendulo1 .......
asked by 20.06.2018 / 16:23
1
answer

Query with many fields and records in MySQL

Good afternoon forum STACKOVERFLOW , I hope you can support me with a MySQL query I have a table of 72 columns and 64 records. The table so requires my boss for questions of standardization. The base has only in the registers the number 1...
asked by 20.06.2018 / 17:10