Questions tagged as 'mysql'

Tagged questions
0
answers

Get best-selling products of the week CodeIgniter

I have this function in the Model, it is about the sales, but this makes reference to the table detalle_venta, which contains the products that were sold, then what I would like is to know how I can formulate the query so that I get the latest 5...
asked by 30.08.2018 / 05:46
0
answers

Use Recyclerview in fragments with data from a BD

I am new to programming, I have a project in which I have been trying for a long time to "inflate" a recyclerview in fragments with Sql data. I appreciate your help ... I will try to detail as best as possible: I work with an activity of a libra...
asked by 30.08.2018 / 02:00
0
answers

upload pdf files to a folder and mysql

good day ... I'm new to the group I just want to bother you with an opinion or advice, I'm designing a software where I can upload to a certified database of different types; I have a registration form where according to the client and type of c...
asked by 30.08.2018 / 00:57
0
answers

Field in MySQL is re-established only in all entries

More than a year ago I came across this problem for the first time, in a table that I have in my database where I have all the articles of my project, the value of one of the fields was reset to 0, the one of each and every ticket he had. Thi...
asked by 10.09.2018 / 06:58
0
answers

Error making Group By in MySQL

I have a table which contains the places where different people have been, I'm trying to get the last place where each of those people was in a single table, for this I'm grouping by IdEmployed and looking for the major date, those two If I get...
asked by 04.09.2018 / 20:22
0
answers

Why does not my login redirect me?

I have been using my system normally but now it does not let me access, I realized that the problem was that my code seemed to be obsolete and I needed to migrate from PHP 5 to PHP 7, try to solve the problem but now it just does not access and...
asked by 27.08.2018 / 18:14
0
answers

Show data from different tables in mysql

I have a problem wanting to show data from different tables, I'm doing an inventory of products, my tables are the following: I want my query to show the last sale and the last order of the products, now my query is this: SELECT pedid...
asked by 27.08.2018 / 22:26
1
answer

Laravel 5.6 Undefined variable: insurer

I have a driver where I made a function so that, according to a selected insurer, I returned the vehicles that are not registered in that insurer. When the function is executed, it sends me the error:    "Undefined variable: insurer" This...
asked by 28.08.2018 / 17:54
1
answer

How to insert several records in the same table with the same name or id

Good morning classmates I have a question about how to insert this into a BD, as far as I understand it is with an array, This is my form <div class="panel-body"> <form class="form-inline" method="POST" action="{{URL::acti...
asked by 28.08.2018 / 16:59
0
answers

Sort MYSQL Concatenated values

I need to order some concatenated values with GROUP_CONCAT but the first concatenated value is not what I want to sort. This would be the SQL code SELECT objects.*, GROUP_CONCAT(mvalues.value SEPARATOR ', ') as value, GROUP_CONCAT(mdescriptor...
asked by 08.09.2018 / 13:48