Questions tagged as 'mysql'

1
answer

Problems in returning data when creating a search in php

I'm creating a search.php for my system, so far everything is OK, however in the while that I created to show future questions that hit with the searched title and their respective links, nothing appears on the page. No SQL erro...
asked by 04.09.2015 / 14:33
1
answer

Implementing logoff on my login system with UNSET SESSION

I have the following login.php file: <?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 FIELD $user = mysqli_real_escap...
asked by 05.09.2015 / 14:50
1
answer

How to recover MYSQL password with mysqld error

But this error occurs: C:\Program Files\MySQL\MySQL Server 5.6\bin> C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld-nt 'mysqld-nt' is not recognized as an internal or external command, operable program or batch file. Ca...
asked by 06.07.2016 / 20:00
2
answers

Remove duplicate data and return the highest value date field

We're migrating signatures from an Access database to Mysql, but before migrating I need to treat some parts of the data. I need: Remove duplicate id's Return the highest value of the date field for these id's In the librecalc itself it...
asked by 05.07.2016 / 21:03
1
answer

Get names of teams in different tables!

Good morning, once again I ask for help. I have 3 tables in the DB to display the teams name, location and the competition, bringing the results with JOIN working, but I am not able to show the names of the two teams in the result. SELECT *...
asked by 07.07.2016 / 16:00
2
answers

Model Relational database with SKU

I am creating a system for selling products and I need these products can have different prices according to their size or color, for this I am using SKU, I am creating the relational model of this database and I would like to know if this model...
asked by 10.07.2016 / 23:18
1
answer

WHERE Clause with Array PHP-MYSQL

I have the following code, but it is not working and I can not find the error. I need to display the 3 lines (123), which are found in $fetch['list_carac'] . <?php include 'conect.php'; $sql = "SELECT list_carac FROM select_carac WHE...
asked by 06.07.2016 / 23:54
1
answer

Capture email data

Good evening. I need some help, I'll try to be as clear as I can. I'm developing an application called, I want to let staff open calls by email, how can I capture this data from the body of the email? For example: I send an email with t...
asked by 27.08.2015 / 02:01
1
answer

How to batch update with PHP and MySQL

I have a .csv file with two columns, one with id and another with status of my product, I need to change these products to status 0 (zero), that is, to inactivate them , but the quantity of products exceeds 400 record...
asked by 10.09.2015 / 18:28
1
answer

Can not add or update a child row

Well, I have these tables with the following structures: Athletes:    id_atletas    id_identificacao    nome_completo    licenca Identification:    id_identificacao    nome_pretendido    dat...
asked by 22.06.2015 / 13:30