Questions tagged as 'mysql'

Tagged questions
3
answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...
asked by 08.06.2015 / 21:53
1
answer

PHP error displaying search result with select [duplicate]

Error while selecting data from the database. $rs = $conexao->query("SELECT FROM cadastro WHERE ID_Cliente = '83'"); $row = $rs->fetch_assoc(); echo $row['nome'];    Fatal error: Uncaught fetch_assoc ()   on boolean in     
asked by 23.07.2017 / 23:46
1
answer

how to bring ten best averages in mysql?

I have two tables: participants and results. In the table of participants I have idParticipant as pk and name; in the results table I have idParticipant as fk, result and date. For the result to enter the ranking the participants must inform...
asked by 23.07.2017 / 06:05
0
answers

simultaneous traffic in classic asp

Good afternoon guys, I have a problem in the company recently we need to migrate an application from one server to another to save time we made an image of the server and uploaded the new one, changed the ip of the new one and put to run the...
asked by 29.06.2017 / 20:51
2
answers

Problem inserting double value in MySQL

query += txtServidor.Text + "',";<br> query += double.Parse(txtVencimento.Text) + ",";<br> query += int.Parse(txtBanco.Text) + ",'";<br> INSERT INTO tbl_associados VALUES(10,'testando','001.318.555-55','categoria','ativo',...
asked by 30.03.2015 / 14:58
1
answer

How to concatenate the return of a query to a string of another mysql

I have the following query: SELECT id AS CODIGO, nome AS NOME, versao AS VERSAO, build AS BUILD, data AS DATA FROM sistema INTO OUTFILE 'D:/servicos/export/exportaVersao.csv' FIELDS T...
asked by 04.07.2017 / 05:13
1
answer

Recover town from database id

I'm getting information from a select, which pulls the states and cities registered in the database. In the value of each select (city and state) is the id of them in the table (only this way to work with the function in AJAX). But at the time o...
asked by 10.07.2017 / 16:52
1
answer

How do I get the query passed by get in pdo from id to code

I'm starting on pdo now, so the games will start for me shortly and my doubt is as follows: I am working on another code from a friend and in his code the get to display the information are taken values by id, however I want the information to b...
asked by 26.06.2017 / 05:35
0
answers

PROCEDURE query slowness problem

There is an email sending routine on my system. Where a bat of windows runs a php file that sends it. The problem is in a stored procedure , which runs directly by the bank, brings the result very quickly ( 0.070 sec question), but when...
asked by 11.07.2017 / 15:43
1
answer

Starts the bank service with a role

I would like to know how I can do a function that as soon as I start the software, I can start the database service if it is turned off. to use java with swing, netbeans and MySQL Thank you in advance.     
asked by 25.06.2017 / 15:04