Questions tagged as 'mysql'

Tagged questions
2
answers

WHERE SQL Functions

I have the following query: $qrysel = "select * from won_auctions w left join registration r on w.userid=r.id where xxx; This query will show a list of users of the won_auctions table and get the user name in the registration table....
asked by 26.11.2017 / 14:45
2
answers

PHP / MySQL - Move from localhost to an online hosting

I created a website with PHP and a MySQL database using XAMPP. Now I would like to have the site online on a host, do I have to change the connection to the database where it says localhost? What procedures do I have to do?     
asked by 26.11.2017 / 14:16
1
answer

Insert field in mysql [closed]

I have a system where you have registered games and the logged in user tries to hit the results of these matches, Each game has a registry id that has the name (game) in the database, I already have an if and else if it matches or erase the scor...
asked by 09.11.2017 / 21:39
1
answer

Types of records repeated in filter

I have a form with a service fetch filter that takes the options from a column of my database table. The problem is that more than one person provides the same service, therefore more has more than one record with the same service, which makes t...
asked by 09.11.2017 / 17:33
1
answer

NodeJS - Wait for 'for' to execute all 'pool.query' until the end

I have a small problem, and no matter how hard I tried to find a solution, I can not think of an excellent one. So I come to ask for your help! So here's the thing: I'm currently developing a betting site (from CSGO game skins) and my problem...
asked by 30.10.2017 / 18:25
2
answers

How to define table that will receive the insert using PHP variable?

I have some tables that follow a pattern:    UserName_SubscribeUserID_User_Semento   Jefferson_Carlos_1_sementes   Carlos_Drummond_2_sementes The name, surname, and ID are stored in the session and retrieved to insert into the database:...
asked by 08.12.2017 / 13:33
1
answer

Syntax error sql, # 1064

I'm trying to create a table, in my database in phpmyadmin. SQL CREATE TABLE IF NOT EXISTS 'chat' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'time' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 'username' varchar(32) NOT NULL, 'text'...
asked by 11.12.2017 / 01:46
1
answer

What is the best way to store Google Maps points in the database? [closed]

I'm developing a system that will store some Google Maps paths of the registered users and structured my table as below: ---------------------- | trajetos | ---------------------- | id | | id_usuario | | parti...
asked by 22.11.2017 / 19:26
2
answers

Decreasing the value of two fields of a table and sorting according to the result

I have the field "killed" and "died" in the table, I need to make the order of the results come according to the decrease of these two values, My query looks like this: $woes = DB::table('woeplayerrank as woe') ->join('char', 'woe...
asked by 23.10.2017 / 21:20
1
answer

Best way to register two foreign keys in a table

I have 3 tables, which are: personal_person , personal_juridica and address . Both tebela pessoa_fisica , and tebela pessoa_juridica use the endereco table. I would like to add two foreign keys in the endereço t...
asked by 04.12.2017 / 18:29