Questions tagged as 'mysql'

Tagged questions
1
answer

Doubt in a Query that does SELECT on two tables

Good afternoon, I am doing a system of scheduling equipment, for better understanding I will put in topics some important information. Each schedule has a numbering of the equipment that will be used in that time range. You can not use two...
asked by 01.12.2016 / 15:39
1
answer

How to encrypt the password in a new user's registry and how do you recognize it in that user's login? [duplicate]

this is the code that processes the registration <?php include_once("conexao.php"); $nome = $_POST['nome']; $celular = $_POST['celular']; $email = $_POST['email']; $senha = $_POST['senha']; $sql = "INSERT INT...
asked by 30.11.2018 / 21:59
2
answers

Form to change value in the database

I have this in the database IwantedaformthatbyclickingtheEnviarbuttonchangedthevalueofpontosoftheselecteduser.ButfornowIonlyhavethis,IdonotknowhowtomakethecodeinPHP.<?php$connect=mysql_connect('xxxxxxxx','xxxxxxx','xxxxxxxxx');$db=mysql_s...
asked by 23.12.2018 / 16:02
2
answers

How to set up a query to bring the last value up based on month and year?

SELECT DadosFinanceirosFiliado_Valor, Filiados_Filiado_Id, DadosFinanceirosFiliado_CompetenciaMes, DadosFinanceirosFiliado_CompetenciaAno FROM dadosfinanceirosfiliado t INNER JOIN filiados ON dadosfinanceirosfiliado.Fi...
asked by 18.12.2018 / 13:31
2
answers

Double query in 1 query

I have 2 tables one of users and one of subscribers, I have an insert that sends to the subscribers table the email of the user that registered and the name of the channel 1st users id | usuario | meucanal 1 | [email protected] | portados fundos...
asked by 31.03.2018 / 05:03
2
answers

I'm having problems with MySQL, I do not know how to pull media

I wanted to know the average number of orders paid per ticket in the Payment table, how would I do it?     
asked by 15.06.2018 / 13:28
2
answers

doubts with select sum () Mysql

I have these two tables, January and February: Eachfieldcorrespondstothedayofthemonth,d1=day01,etc.Ineedtocreateaselectthatshowsthemonthlyvalueofeachaccountplan,forexample: How would this sql be?     
asked by 18.03.2017 / 21:52
2
answers

Get number of elements depending on the maximum number of elements per group [closed]

I have two tables and I want to get the name of the A table depending on Num3 . For example, in the A table, we have num2 and in the B table there are values corresponding to Num1 . What I want i...
asked by 06.12.2016 / 23:51
1
answer

How to check day of the week being 1,3,5

Galera, I have a field in my table that holds the day of the month, example But in the same field I am recording the information like this: 1,2,3,5,22 Today is 22 DAY (NOW ()) = 22 See that in my field the day is 1,3,5 as it i...
asked by 22.06.2017 / 16:43
2
answers

PHP Error "mysqli_query () expects at least 2 parameters, 1 given" when sending information from multiple input [closed]

I'm making a page with a product value record, would you like to know how to Insert Into of values while ? <table style="width: 100%;"> <thead> <tr> <th>Item</th> <th>Código</th> <...
asked by 30.06.2017 / 16:02