Questions tagged as 'mysql'

Tagged questions
1
answer

Several cities in one project [closed]

Good afternoon! I wanted some tips. I'm developing a project for a classified website, I want to use it with several cities here in the region, how can I make it so that on the same site the user select their city? For example, the user...
asked by 02.03.2015 / 19:13
1
answer

Error # 1142 MySQL

Today in my system I came across this situation. Food my SELECT with this code: "SELECT p.codigo,p.nome,p.fantasia FROM pessoas p LEFT OUTER JOIN pessoas_define pd ON pd.cod_pessoa = p.codigo WHERE pd.advogado = 'T' AND p.apagado =...
asked by 03.03.2015 / 12:27
0
answers

Problem with join query PHP

Good, And the following I have a query JOIN that makes me the query to 3 tables, that searches me in the bank for all the notifications of the followers of the currently logged in user. The problem is that I was now trying to fe...
asked by 14.03.2015 / 19:33
3
answers

How to compare data with accents in the database?

I am having the problem in a search I made in that user filter content by district and county, it works fine when I choose district and county without accents but when I choose a district and a county that contains accents does not give me any v...
asked by 19.02.2015 / 01:19
7
answers

How to do a dump of a MySQL database with PHP?

Currently, to export only the structure of a particular database, I use the following: mysqldump -h host -u usuario --no-data --database banco > dump.sql -psenha This generates an SQL file, all solved. However, this is a manual process t...
asked by 05.02.2014 / 06:26
0
answers

Strip_Tags + htmlentities - No connection to the variable

I have the following problem. I have a database connection, which uses a function called $ FLD to bring the fields I want: $FLD="idfca, dtafca, solfca"; After this I'm posting $ FLD to a variable: var fld = "<? echo $FLD; ?>"; An...
asked by 23.02.2015 / 15:09
0
answers

Bring older results with Long Polling

I'm creating a system and I want it to bring all the results already stored in the database, but it only returns the recorded data from the moment I refresh the page, for example if I enter 10 records in the database, the 10 will appear the mome...
asked by 23.02.2015 / 18:31
1
answer

cart php amount [closed]

I have a cart made in php and the products are in the database, as I do to place a restriction on a particular product eg: The product number 4 in my database I want the quantity of it only goes up to 100. Thank you for being able to help.     
asked by 19.05.2015 / 04:21
0
answers

Mysql Longblob only accepts file up to 128mb

Create a table to store files, but every lifetime that I send a file above 128mb all columns are null except the id. I also noticed that it saves only images, another type of file it does not want to save, like zip file for example. CREATE TAB...
asked by 25.04.2015 / 07:41
1
answer

Flash-php-Mysql [closed]

Here I am with one more issue of actionscript, I will be very objective. In the flash I designed a car, the 2 wheels are 1 button, which when clicked makes an sql query to a table with fields equal to the name of the button created for the wheel...
asked by 16.04.2015 / 12:04