Questions tagged as 'mysql'

2
answers

1054 - Unknow colunm in on clause

What is wrong with this query? SELECT clientes.idClientes, clientes.nome, clientes.bloqueado, planosclientes.idPlanos, planos.nome, enderecos.bairro, enderecos.cidade FROM planoscliente...
asked by 05.10.2015 / 14:39
2
answers

Optimizing MySQL Connections

I have a pertinent question regarding the connections in my database. I was told that with each new connection to MySQL a portion of the RAM is reserved for this connection. I have several applications developed in PHP that connect in the sam...
asked by 01.10.2015 / 16:09
2
answers

Checkbox multiple and save in bank

I have a form where I can mark several checkbox at the same time and wanted to know how to identify the ones that are marked and save them in the database. In the database I will have a table and a column for every checkbox beca...
asked by 09.10.2015 / 00:10
1
answer

How to do a countdown with jQuery?

I'm doing a script for study in this link and would like to implement in this script a countdown timer as it does on collective purchase sites and would like the help of you to accomplish this task. What I have already done is to register...
asked by 08.10.2015 / 03:04
1
answer

Replace if loop is empty

Well, I've got a question because I was kind of "stuck" without knowing how to do it. I have the following code: <? foreach($data as $index => $row) { $className = $index % 2 == 0 ? "class" : "class-1" ?> <form action="" name=...
asked by 24.04.2015 / 19:18
1
answer

mysqli_connect () error: (42000/1044): Access denied for user [closed]

This code is giving error.    Warning: mysqli_connect (): (42000/1044): Access denied for user 'u469236901_roota'@'10.2.1.41' to database 'u469236901_sysU' in /home/u469236901/public_html/RegisterUnity.php on line 7       Warning: mysqli_err...
asked by 27.04.2015 / 23:46
1
answer

Problem with mysql connection in C #

I created a connection class for my application in Xamarin, but every time I try to connect it throws this exception:    "The type initializer for   'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an   exception " Follow the...
asked by 20.08.2016 / 01:06
1
answer

Separate rows by group and their percentage of total

I need to get the top 10 results in my table and their respective percentages, separating by groups. For example the table: +-----+-----+ |id |fruit| +-----+-----+ | 1 | or | | 2 | ban | | 3 | or | | 4 | or | +-----+-----+ It w...
asked by 26.12.2014 / 23:40
1
answer

MySQL returning null wrongly - MYSQLI PHP

I'm trying to do a SELECT through PHP's mysqli, but it's returning null in all parameters of the object returned by $ mysqli-> query ($ sql) >. ItstillreturnstherowsthatIselectedfromthetable,butsomevaluescomenullalso: Follow my code:...
asked by 22.12.2014 / 20:29
2
answers

Insert the last data of a table into a second table

I have a problem with INSERT in PHP. I have a table named products_1 and another called products_2. Table 1 has the same products as the second, but with 5 more products, ie ID 11, 12, 13, 14 and 15 are not inserted in products_2. I need to "cop...
asked by 08.12.2014 / 14:57