Questions tagged as 'mysql'

Tagged questions
1
answer

Remove Group_Concat and list each one separately

I want to remove group_concat to list each one separately, any tips? SELECT U.login, (SELECT Group_concat(AC.curso ORDER BY id ASC) FROM alunos_cursos AC LEFT JOIN cursos C ON AC.curso = C.id W...
asked by 20.09.2018 / 13:56
1
answer

SELECT with Join Join MYSQL

Table - log_tables_restaurants id | id_restaurant | id_admin | id_user | action 1 | 10 | 2 | NULL | adicionou 2 mesas 2 | 11 | 3 | NULL | removeu 2 mesas 3 | 20...
asked by 20.09.2018 / 13:47
1
answer

Create slug across the MYSQL database

I have an older MYSQL database and it has a news table and I needed to create a "slug" column to save the news slug. So, I would like to create an automatic slug for all records that are registered in this table. Table: Columns Titulo --...
asked by 16.08.2018 / 15:57
2
answers

show input when selecting an optin within the while of php

Good morning! Personal is as follows, I have a combobox that displays all the records of a table, until that part I could unroll. However, I need to show an input when one of these records is selected and hide this same input when noth...
asked by 13.08.2018 / 17:05
1
answer

Better understanding the max_user_connections count in MySQL

If on a page I have connection and query more than one database will count as two connections And if it's the same database but has multiple queries (select) will count as multiple active connections? Why do not show proccesslist become act...
asked by 13.08.2018 / 21:40
1
answer

Pass MySQL result to Highcharts

I have the following array, and I need to convert it to Highcharts interpret and generate the graph, how can I iterate my array, since it returns the duplicate region but with different sale value? Where the X-axis would be [name], the name w...
asked by 13.08.2018 / 14:27
2
answers

Show Value in Json + Mysql + PHP

I need to do this, but coming from the database .... I do not know how to do it function decodificar($id) { if ($id == '1') { return json_encode( array( 'id' => '1', 'desc' => 'descricao do produto',...
asked by 17.09.2018 / 17:45
1
answer

Help with Join in Mysql [duplicate]

I found several questions / answers about join on the site, but I still can not create the command I need. What I need is the following: I have the following tables: item (I have two items registered) id descricao --------------- 1 - d...
asked by 06.08.2018 / 13:35
1
answer

Information gets out of the table in while

Only the first tbody information is displayed but the others appear in lines outside the table. That's the part of my code. What could be making this happen? <?php } }else { $sqle = mysqli_query($conn, "SELECT * FROM jsondados...
asked by 08.08.2018 / 18:28
1
answer

Query problem [duplicate]

You're giving the error Warning: mysqli_num_rows () expects parameter 1 to be mysqli_result, boolean given in. Can someone help me? $mes = date('m'); $ano = date('Y'); $sql = mysqli_query($conn, "SELECT * FROM table WHERE empresa='empresa'...
asked by 09.08.2018 / 20:14