Questions tagged as 'mysql'

Tagged questions
3
answers

Get the same result as a query with join

I have already researched some forums, looked at my books and searched other sources, but I did not find anything that solved my problem. I have a query that queries the open value in a given table: select negociacao_parcela.data_pagamento,...
asked by 22.01.2018 / 20:41
1
answer

Error in Query Mysql

I have a page in php that needs to query in 3 fields on Mysql Bank. Campo Aprovado Campo Reprovado Campo Resolution $select = mysql_query("select * from denuncia where (resolution is NOT NULL) AND status='aprovado' or status='reprovado'");...
asked by 26.01.2018 / 19:28
0
answers

Connect syslog to remote mysql with tls?

Good afternoon guys. I'm trying to make the syslog connection with a remote MYSQL database that uses tls. by the command line the connection is: mysql -ssl-ca = / path / server-ca.pem --ssl-cert = / path / client-cert.pem --ssl-key = / path /...
asked by 19.01.2018 / 19:12
0
answers

Group Results With Subquerys

   I need to make the return of this query the number of items per category and the number of items by subcategories also properly grouped, For example: Categoria Quantidade Subcategoria Quantidade A 4 A1...
asked by 23.01.2018 / 11:44
0
answers

Query - SQL Server with stuff

Please, in the query below I want you to bring it as follows. contato andreia, marcos, juliana ie on the same line. In the query, I used stuff , but to no avail. Today she's bringing it that way. contato andreia marcos juliana...
asked by 23.01.2018 / 16:11
0
answers

Image does not appear - php

I'm trying to bring the Mysql database image to a PHP page but it does not appear. Follow the code: <!doctype html> <html> <head> <script src="jquery.js" type="text/javascript"></script> <script src="jquery...
asked by 19.01.2018 / 14:12
1
answer

How to Join with Sum and Group By

I'm trying to do a SQL query using Join between two tables. The first table is a table that contains monthly savings values for a given project. Each time someone registers a project on the site, a PHP routine generates 12 values, one in the cur...
asked by 24.01.2018 / 22:27
0
answers

get_where for PDO

I want to change get_where to mysql or PDO, but I do not know! Help ...! public function get_where($table = '', $where = NULL, $limit = NULL, $offset = NULL) { if ($table !== '') { $this->from($table); } if ($where...
asked by 18.01.2018 / 22:57
2
answers

Update record on the same page

I have a page PHP that displays the DB information according to a SELECT I made ... now I need that when I click a button I only update 1 table field. How can I do this update direct, on the same page php , without...
asked by 26.01.2018 / 14:53
1
answer

How to make several separate selects with laravel 4.2?

Hello, I need to do a select in a table, but if I do not receive the month by the parameter I must do the SUM method to sum every month if($month != 0){ $dbRegister = tb_data::selectRaw('tb_data.total_points'); }else{...
asked by 26.01.2018 / 15:06