Best answeres tagged with mysql

2

answers

Difficult to mount query for Search in multiple columns

asked by 08.09.2017 / 23:16

1

answer

In mysql it is possible to create an extra line if 2 or more rows are the same [closed]

Hello, I would like to know if it is possible to create a fourth line for mysql based on Titles that are repeated as in the first table where the game The Witcher® 3: Wild Hunt repeats 3 times and is generated on 4 lines based on second table?...

asked by 19.08.2017 / 13:24

2

answers

First visit message on the site

I have a system that whenever the client logs in, counts another visit, and on the first visit a welcome message appears. But if the user reloads the page again or changes the tab and returns to the main page, the welcome message appears again....

asked by 13.09.2017 / 18:32

1

answer

Mysql error - phpmyadmin: Access denied!

I have this problem with phpmyadmin, it was working normally, but when I typed: "mysql" in the linux shell it did not open mysql, just when it was typed: mysql -h 127.0.0.1 -P-3306 -u root. / p> Then I saw some articles and modified or deleted...

asked by 14.09.2017 / 04:08

2

answers

Bank query with accent on the table

I know it's kind of absurd, but unfortunately I came across a situation that I do not know how to circumvent. The company has a system that records in ACCSSES baco and some tables theme accentuation and special characters Ex: Code - Action -...

asked by 26.07.2017 / 15:35

1

answer

Error trying to create new MySql table

I am encountering an error when trying to create a table in my database in MySql. I read about this error in other occurrences here in the stackoverflow, and it seems that it occurs when you try to use a MySQL keyword where it should not be u...

asked by 26.07.2017 / 01:18

1

answer

How to divide the results from the DB into different lines as in an online store

Hello I'm trying to distribute the results from the DB into lines with 3 results at a time, as we see in many online stores, but the formatting is quite disorganized. I've still tried to open 3 results through an If clause, but as I said a...

asked by 26.07.2017 / 20:12

1

answer

Get specific button with Jquery in repeat structure

while($reg = $stmt->fetch(PDO::FETCH_OBJ)) { $id = $reg->id; echo "<div class='altpost' id='$id'></div>"; echo "<form id='$id' class='faltpost' method='post' action='altp.php'><input name='naltpo...

asked by 28.07.2017 / 01:37

1

answer

Get the last ID when inserting into the MySQL database

How to get the last ID when inserting in MySQL BD using PHP and MYSQLi. $inserir = $conexao->query("INSERT INTO cadastro (nome, sobrenome) VALUE ( 'Fulano', 'De tall' "); echo $id = mysqli_insert_id($conexao); You...

asked by 23.07.2017 / 22:38

1

answer

Javascript excerpt does not work

I do not know what I'm doing wrong, maybe it can be simple, but it does not give me the expected result. In creating the html component: <li class="dropdown notifications-menu"> <a href="#" class="dropdown-toggle"...

asked by 17.08.2017 / 01:21

Questions tagged as 'mysql'