Questions tagged as 'mysql'

Tagged questions
1
answer

Mysql SELECT with JOIN and LIMIT in child table

Hello, I would like the help of the collaborators. I have a table "catalog" related to another table 'images'. Each record in "catalog" has n pictures. I need in a SELECT with INNER JOIN images, only 3 images are returned for each row of the cat...
asked by 16.04.2017 / 02:59
0
answers

Chart that updates every n seconds

I'm using Google Charts and I need to make a chart that updates both the x-axis and the y-axis values every n seconds. I need 50 data to be used for each update, so I used one SELECT max(id) FROM tabela_arduino to read the last value...
asked by 18.04.2017 / 16:41
1
answer

Generate sql from a return of a js

Good morning guys over stack. For some time now I've been hammering to find a solution to a problem that has appeared, that nothing comes up in my head. I have a form, where this form will make a filter in the js datatable. This datatable I u...
asked by 18.04.2017 / 15:22
1
answer

How to decrease if amount

The code below should do the following things: 1 - Search for companies in the database. 2 - Look at the table in the month which companies will be worked on. 3 - In this month table is drawn that was done with the companies, all and fo...
asked by 18.04.2017 / 13:55
0
answers

Page load equal to G +

I'm venturing into PHP and making a simple administrative dashboard, no framework, to manage registered users, how can I load pages in admin without reloading the side menu and the navbar, like G +? > Note: You do not need to have the effect,...
asked by 07.05.2017 / 20:32
1
answer

Update record five minutes after insertion

I have a table with the following structure: tb_simulation: id(INT) | codigo(VARCHAR) | flag_valido(INT) | data_hora(DATETIME) | valor(DEC) I would like five minutes after the registry was entered the database automatically changed the...
asked by 07.05.2017 / 19:30
0
answers

Select option according to the base date

Currently I have a selection field where you have several options and only one that the user chose, except that I wanted to look for the one that he chose automatically by the database. I use the code: <option <?php if ($company == 1 ) e...
asked by 07.05.2017 / 15:21
1
answer

Select an ID from a radiobutton query and store it in a session

I'm having trouble getting an ID from a query using array and storing it in a session to use it on other screens. Any help I appreciate. Check the code below OrderScreen<!DOCTYPEhtml><html><head><title>ProjetoWeb-Cons...
asked by 14.04.2017 / 01:49
0
answers

Data being duplicated in date attributes within a foreach

I'm creating a star rating system where I pop the posts and show sorting. The problem is in the posts that receive the same note. You are not picking up the note of each post , but of a single post and showing the same note in the others....
asked by 14.04.2017 / 16:34
1
answer

Warning: mysqli_fetch_object () expects parameter 1 to be mysqli_result, boolean given in /home/omeganim/public_html/index.php on line 39

I need help solving this error !!! Warning: mysqli_fetch_object () expects parameter 1 to be mysqli_result, boolean given in /home/omeganim/public_html/index.php on line 39 The code is this: $pagCorrente = 1; if(isset($_GET['pag']))...
asked by 22.04.2017 / 02:11