Questions tagged as 'mysql'

Tagged questions
2
answers

Problem with mysql_query, the data does not fall into the SQL database.

Hello, I can not execute this query, I have echoed this variable and all the data is being passed, but it does not enter my DB. When I copy the command and paste inside the phpMyAdmin query it works. Could someone give a help? Thanks! :) $s...
asked by 11.06.2018 / 20:27
1
answer

Form sending to bank when updating page

Hello, I have a problem on my form which is as follows. I fill in all fields and click the submit button and everything works fine. When I give an F5 to update the site, it resends the same registration I made for the bank again. If I keep gi...
asked by 25.12.2017 / 16:29
1
answer

Storing questions and answers in the bank

How can I store questions in this style: a. __She__ is alone in the park, sitting by__herself___. (She/Her/Herself) In the bank with these spaces to fill and be able to use these spaces in android for example.     
asked by 14.12.2017 / 14:50
3
answers

Load DataGridView with MySql

I have the following problem to display the data in a gridView pulling from the MySQL database public string CarregarAluno() { string retorno = ""; string sql = "select * from alunos"; MySqlConnection conn...
asked by 29.11.2017 / 12:05
2
answers

How to do Sub Select in SQL

I would like to know if anyone can help me because I could not do the sub select command between two tables, could anyone help me? I need to pull the name of the book that is in the book table together with the data in the sales table. Tab...
asked by 27.08.2018 / 21:11
1
answer

Different results with the same SQL statement

Speak programmers, easy? I've done a lot of research not to repeat questions here, but I really do not understand why the SQL statement works in MySQL Workbench and the Java / JDBC SQL string does not. I have two game and category tab...
asked by 24.08.2018 / 23:54
1
answer

Error in php if, login authentication system

Hello, so I'm trying to make a simple login system with php and mysql, but it's giving error in my if. I already moved ... too much and nothing, when it seems that right it does not authenticate you put any password q or login name and will. Thi...
asked by 09.11.2017 / 00:01
2
answers

How to do sum of fields between different tables in MySQL

I have the following structure: PURCHASE id_compra desc_compra valortotal_compra data_compra id_colaborador COMPRAPROD id_compraprod id_compra id_produto qtd_compraprod valorunit_compraprod valortotal_compraprod...
asked by 02.04.2018 / 19:26
2
answers

mysql_num_row with inner join

I have 2 tables: Leads Stores The relationship is as follows: 1 shop - > N leads I need to list the number of leads registered for each store and then sort by descending order to know which store has the most leads The i...
asked by 26.04.2018 / 00:57
2
answers

Extract exploded results from a column

I inserted several data within the same column with implode , now I want to extract the results of the query with the explode in order to get the data separated and then to work. I have the code this way, but it is not returning anythin...
asked by 24.04.2018 / 12:33