Questions tagged as 'mysql'

1
answer

How to search for the last 5 pictures inserted in the bank and show on a carousel? [closed]

I want to get the last 5 pictures in the bank and show them in a carousel, with their title, and those marks that indicate the image being viewed. I'm working with Laravel 5.1 and mySql. For more clarification, here are some tips: To search...
asked by 30.03.2018 / 14:12
1
answer

Query error

What's wrong? I did everything right, I researched and it retakes the error to me: Notice: Trying to get property 'num_rows' of non-object in C:\xampp\htdocs\tipo\consulta-online.php on line 21 What can it be? <?php $servidor...
asked by 11.03.2018 / 03:55
1
answer

Compare 2 rows from the same table

I need to make a MYSQL query. I have a table in which I have column "data_emission" and "date_wind". I need to find all the lines in which they have the same expiration date, but different dates of issue. How can I compare rows like this from th...
asked by 28.02.2018 / 20:28
1
answer

Something equivalent to sstream library from C ++ to C

I need something similar to the stringstream that has in C language for C language, I need a lot of it because I want to perform querys on a database using C (C mysql connector). As I had no idea something like what I had in the sstream libra...
asked by 01.03.2018 / 02:39
1
answer

How to make a query depend on the result of the other? [duplicate]

Consider the following table: +----+----------------+----------------+--------+ | ID | fk_resource_id | fk_language_id | value | +----+----------------+----------------+--------+ | 1 | 1 | 1 | Entrar | +----+-----...
asked by 01.03.2018 / 21:14
2
answers

Generate multiple records in MySQL

In MySQL I have two tables: CLIENTS | codigo-cliente | nome | grupo | valor | |----------------|------|-------|-------| FINANCIAL | codigo-cliente | codigo-boleto | grupo | valor | |----------------|---------------|-------|-------|...
asked by 02.03.2018 / 04:16
1
answer

Select top-sellers in each category

Hello I have a table with id, id_category, product name and quantity sold. I want to list the first products sold in each category, even if the second or third product in the "A" category, for example, sold more than the first in the "B" cate...
asked by 25.02.2018 / 18:23
2
answers

VIEW and JOIN, return the product, and the value with the most recent date!

I have the following tables that I created. CREATE TABLE produto ( codigo INT UNSIGNED NOT NULL AUTO_INCREMENT, nome VARCHAR(128) NOT NULL, url VARCHAR(255) NOT NULL, qde_min SMALLINT UN...
asked by 23.02.2018 / 21:24
1
answer

Print all pages generated by PHP and MYSQL

Hello, I am making an extract in which you can generate several pages, I used a very simple paging system using limit in the querys of mysql . > The problem is that several pages are generated and at the time of printing it only prin...
asked by 21.03.2018 / 12:49
1
answer

Transform the DATA entry into a PHP / JAVA variable

I hope you understand the situation: By programming a web page, I have created a data field where the user chooses the date that to filter the information contained in the site, ie only display information that reflects the chosen day o...
asked by 20.03.2018 / 20:15