Questions tagged as 'mysql'

Tagged questions
2
answers

Duplicate values in php

I have a table in the bank that is called a toy, inside it I have the columns name, total, amount available and quantity donated. But I want to show only the name, the total and the total amount donated. When I use the code below that I know...
asked by 19.09.2015 / 20:41
0
answers

PHP file upload that passes data to MYSQL

It will be difficult to explain what I want but I will try to summarize it in 2 small paragraphs. Come on I have a script that passes data from file .CSV and .TXT to database MYSQL , but it only works when I put the...
asked by 28.03.2016 / 15:09
0
answers

PHP Mailer + MySql

Hello, I have a page to fix that performs 2 functions from the completion of a form: 1- send form info to MySql bank - running ok 2 Confirmation E_mail with the data filled in the form. here's the problem. This part of the code is done in...
asked by 28.03.2016 / 09:36
1
answer

List database file and place a new line after a certain number

I've been trying to find a small solution for days: Example: I have this code: //LISTAR AS PLAYLISTS $dados_playlist = mysql_fetch_array(mysql_query("SELECT * FROM playlists where codigo = '".$_POST["playlists"]."'")); At the time it...
asked by 29.07.2015 / 23:50
0
answers

Referencing a group of ID's resulting from 'group_concat'

I have a select that returns the equally repeated lines, along with the total. I need to reference this group of ID's to pass as an argument. The result of my query is the array below. Basically it counts how many lines has Papa Charlie in...
asked by 29.07.2015 / 21:23
1
answer

Data returning with space

I am making a ajax call with jQuery on a controller in CodeIgniter . The problem is that when jQuery returns me the data, it is coming with some spaces in front of the result, being for example: (ESPAÇO) (ESPAÇO) (ESPAÇO)...
asked by 01.08.2015 / 23:57
0
answers

Select Advanced separated by hour

I set a SELECT to return some information from my separate table by time and date. Until that part everything is working correctly. Now I need it to select the same data only from another date, which is the same table. My SELECT...
asked by 29.07.2015 / 15:17
1
answer

Google Chart pass ID of a bank column

I would like to know how to pass a value transparently to the chart, I have to get the ID of a column in the database. The way I'm doing I need to pass as follows: Column Title | ID
asked by 17.07.2015 / 10:33
0
answers

Small problem with pure PHP pagination

Hello, I have the following function that does the pagination according to what the user typed in the search input: function pesquisar($botao, $input, $conteudo) { if(isset($_POST[$botao]) || $_GET['pagina']) { $busca = $_POST[...
asked by 17.07.2015 / 19:03
1
answer

MySQL sometimes stops responding

I have a Web application with MySQL database on a dedicated server with 24GB of RAM and Windows 2008 Server. I set up my.ini so that mysql can use about 1/3 of the RAM. But sometimes MySQL stops responding and the Web application can no longer a...
asked by 20.08.2015 / 19:38