Questions tagged as 'mysql'

Tagged questions
2
answers

Login PHP and MySql generating error mysqli_fetch_array ()

Good morning! I have the following code to log in to the system: <?php require_once('conexao.php'); // FETCH DATA FROM FORM USING METHOD POST // IF BUTTON NAME "LOGIN" IS SET if (isset($_POST['login'])) { // FETCH DATA FROM INPUT...
asked by 01.09.2015 / 16:21
2
answers

What jQuery event do I use to query the database?

jQuery(function($){ // Chamando as funções $('#busca-cidades').keyup(function(){ ... I am doing a query in the database and returning this query formatted with html / css and the query is in WordPress SQL. So far nothing very differen...
asked by 13.07.2015 / 00:25
3
answers

Keep selected option loaded dynamically

I need to keep the option chosen in the combobox after the page is submitted, I have a function that does this, but only for combobox static, for the dynamic combobox it does not work. I'm already searching for hours and can not find anything....
asked by 03.08.2015 / 01:15
1
answer

MySql insert with "Connection" between inserts

I have a problem here. I need to upload multiple files and insert them into different tables. The product table contains the details of the products and the photos table the files to access the images, but I need to list them according to...
asked by 20.07.2015 / 21:17
2
answers

Return the data difference of two sql tables

I have a ESCOLA table with ID_ESCOLA and NOME_ESCOLA and another table PROFESSORES that contains a FK_ID_ESCOLA and NOME_PROFESSOR . I wanted a table that would give me the name of all the schools, but th...
asked by 26.06.2015 / 20:06
1
answer

"Fine tuning" in SELECT for a ranking system

I'm having difficulty using MySQL. I've been asking here already, and I've done a lot of testing and progress in crafting a select for a ranking . I have a "player" table that holds among other infos, nome_jogador and pontuacao...
asked by 12.02.2016 / 02:16
1
answer

I can not change records from a database table

It is the following, I need to make my site can change login data, registered in the database. I've made the codes, but when I click to change, nothing happens ... The files I'm using: alteraadm.php $conexao = @mysql_connect("localhost","ro...
asked by 15.11.2015 / 03:24
1
answer

Search does not work correctly when using JOIN

I have the SQL below and the parameter where the JOIN contratos co ON c.email != co.email part is not working. My goal is that c.email is not in the contracts table. No SQL error is shown. If I do so JOIN contratos co ON c.em...
asked by 28.09.2015 / 00:42
2
answers

Display different objects with equal groups

I tried in several ways, got different results some good, others not so much. I would like to do something like store group / objects in MySQL and display on screen using PHP I have this table Iwouldliketodisplayaresultsimilartothis(madei...
asked by 29.09.2015 / 01:02
1
answer

Date Range VARCHAR / DATE

I have a date field of type (type VARCHAR ) in my table, and I recently had to search the database with date range. And for this I used the Between operator, getting something like: BETWEEN 15/08/2015 AND 25/08/2015 . So go...
asked by 27.09.2015 / 01:30