Questions tagged as 'mysql'

Tagged questions
1
answer

save questionnaire time

I made a questionnaire with php and javascript, that's all right. Just a little detail I'm not sure what the best way to do it. The questionnaire has a time to be answered, and I would like it if the responding user leaves the page or updates...
asked by 19.01.2018 / 12:50
2
answers

Select multiple tables by arranging by date

mysql> SELECT * FROM COLABORADOR; +----+----------+ | ID | NOME | +----+----------+ | 2 | FULANO 2 | | 3 | FULANO 3 | +----+----------+ 2 rows in set (0.00 sec) mysql> SELECT * FROM JORNADA; +----+---------------------+--------------...
asked by 15.10.2017 / 23:29
1
answer

Query in MySQL when there are two ids

I have a table in MySQL that writes connection information from an IP PBX. It always stores the connection with a uniqueid itself. But I noticed that the time in the URA is also stored in the same table with the same uniqueid ....
asked by 27.11.2017 / 16:39
1
answer

MySQL Subquery Busting Error

I have a select to display 4 fields, but a field that is valor_pago is from another table, but I can not use JOIN otherwise the return of records conflicts So I created a Subquery but my question is: how do I get my amoun...
asked by 28.11.2017 / 19:42
2
answers

Update database modal

I made a code that updates the data entered by the user in the database, however, he is giving the message that the data has been updated, but does not update anything. The system works like a search. The user types the number (number and primar...
asked by 29.11.2017 / 13:21
1
answer

Adding values from a field in a table

I have a table where I store the freight values, but when the cart is updated with the freight value, this value is also updated in the table. However, if order # 1111 has 3 items in the cart, it will include in that table the updated freight va...
asked by 15.11.2017 / 20:49
1
answer

Help with a mysql query

I'm breaking my head here with a query I set up where I get the dates entered in the form and search the database. it does the query only does not bring all the data If I inform the start date from 01/01/2017 to today's date 15/11/17 it on...
asked by 15.11.2017 / 22:53
2
answers

Form error online

In the browser the following error has occurred, I have tried everything if you can help    Parse error: syntax error, unexpected $ end, expecting T_VARIABLE or   T_DOLLAR_OPEN_CURLY_BRACES or T_CURLY_OPEN in <?php echo "NOVO MOTORISTA"...
asked by 25.10.2017 / 03:35
1
answer

Checkbox inside While

I need to replicate this table from the company's ERP system to the WEB system. ButusingthecodebelowtheimageIhavethevalueofthevariablesthatare0and1. <tableborder="2"> <tr> <th>  Id  </th>...
asked by 26.10.2017 / 19:26
1
answer

Error trying to login user with mysql

I am trying to log a user to my system using a MySql database, but it is returning me a NullReference error. I've tried to check if it was null before converting to string, but the error persists. Why does the mistake happen? How to fix? Meth...
asked by 30.08.2017 / 02:06