Questions tagged as 'mysql'

Tagged questions
2
answers

Java: Connection Class Error [closed]

How to correct this error? This is preventing you from connecting to the bank .... private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // Eventoos do Botao inserir try {...
asked by 23.11.2015 / 14:48
1
answer

Place items SELECT Mysql Side by Side with Bootstrap

Good afternoon, I'm doing an appointment at a bank for a real estate site. I would like this query to generate real estate side by side, not one below the other. Is there a way to do this using Bootstrap? If not, how can I do it using tabl...
asked by 05.12.2015 / 19:22
1
answer

Sort While By Insert in MYSQL Database

I'm wanting my while instead of creating the "element-item" block down, create the block up, that is it will sort from the newest to the oldest and not the oldest to the newest EXAMPLE: What he's doing: BLOCO ID1 - BLOCO ID2 - BLOCO ID3...
asked by 30.11.2015 / 17:40
2
answers

Relate and Compare MySQL and VB6

They passed me a system of a company to update, they have 3 MySQL tables 'vendaesc, venda, venda_forma_payagem'. From what I understand the vendaesc table is used to store the sales items. I need to create a report that brings me the data of...
asked by 02.12.2015 / 21:07
1
answer

View with store procedure, mysql

I have a procedure correct and a view that uses the parameter of the procedure, except that the view does not see the parameter of the procedure, how to solve this problem? Create a store procedure that, from the customer's cod...
asked by 01.12.2015 / 20:59
1
answer

Save data to a table in MYsql database using php

How to save data from the top column and line example I have description (row) + date (column) + value (column) = same row column. <form name="frmitementrada" id="frmitementrada"> <table width="89%" style="font-size:12px;" id="tab...
asked by 24.01.2016 / 15:34
1
answer

System to identify that the user owns the topic PHP + Mysql

GOOD LATE. I'm doing a help forum on my site, and I came across a question. I tried to make sure that, when the owner of the topic was in doubt, he could close the topic himself. However, I have a certain message when trying to display the messa...
asked by 03.02.2016 / 15:39
1
answer

Select Comparing Periods

I need to make a select that compares two sales periods, totaling by product. Today I have this select that does this, but only for a period (01/09/2014 to 09/30/2014) SELECT ACC.PRODUTODESC PRODUTO, Sum(ACC.VALORTARIFA)...
asked by 05.02.2016 / 15:03
1
answer

How to convert date at select time and return via Json

In my form I am using Bootstrap-Datepicker so that the user can enter the desired date at the time of registration, it works correctly, but at the moment of making a change I am trying to bring the date in the format 99/99/9999 wit...
asked by 24.11.2015 / 12:38
1
answer

Capture Month in date field

I have a date field in my MySQL database and it stores the date of type y-m-d which is already used in other queries, but now I need to capture only the month to make a sum. The code I have is this date_default_timezone_set('A...
asked by 04.11.2015 / 23:59