Questions tagged as 'mysql'

1
answer

Install MySQL from the source code in Ubuntu

Greetings, I am a newbie in the use of GNU / Linux systems and I am having problems installing MySQL from the source code. If someone could offer me instructions or a link to a detailed guide I would be quite grateful. My version of Ubuntu...
asked by 05.11.2017 / 12:08
2
answers

Obtain registration with two matches in the same relationship table

Dear I need to get a record that has two relationships, I explain: I have the tables:    CONTENT: id - title - description       CATEGORY: id - title       CONTENTS_X_CATEGORIES: idContent - idCategory Whenever you want to get a "con...
asked by 16.01.2018 / 17:22
1
answer

Save image in blob or by route? [closed]

What would be most appropriate and a good practice to save images in database By route or within the manager as data     
asked by 25.10.2017 / 11:23
1
answer

PHP Notice: Undefined index, variable

I have this error: PHP Notice: Undefined index: user in /home/clubbrit/public_html/socios/administrador/header.php on line 6 PHP Notice: Undefined variable: nombre in /home/clubbrit/public_html/socios/administrador/header.php on line 67 PHP...
asked by 25.10.2017 / 18:59
2
answers

Relate 3 tables in mysql with restrictions

I have 4 tables, some images, some categories and some attributes for each category. The fact is that I need a fourth table that relates for each image an attribute for a category, but at most one attribute of each category. Images ImageID...
asked by 25.10.2017 / 17:35
1
answer

Do I have trouble doing an INSERT with php and mysqli?

I have this mysqli_query($conect,"INSERT INTO Clientes (Nombre,Apellido,Direccion,Provincia,Ciudad,Fono,Email, nombreEnv,apellidoEnv,provinciaEnv,ciudadEnv, direccionEnv,fonoEnv,emailEnv,Emailusua) VALUES ('$nombre','$apellido','$direccion',...
asked by 05.11.2017 / 20:11
1
answer

Sessions in php for a certain user

Good day I'm working on WampServer php and mysql with sessions I have a problem having many users I want when I log in to show the data only of that user, my problem is how to assign an id so that when I start open with data only of that user. I...
asked by 05.11.2017 / 16:17
2
answers

"Select" with data from different tables

I need help. I have to create with PHP , the options of a select with the data coming from different tables MySql , and once selected, insert them in another table. I have this query SQL : $consulta = "SELECT idCausa, Deudor_idDeu...
asked by 06.11.2017 / 07:31
1
answer

error in select mysql c #

I have the following method that consults a range of dates and returns an email associated with a client but when you run it from the application, it does not return anything but if you execute it from the mysql command line if it works D...
asked by 29.11.2017 / 18:46
1
answer

Sql query of dates

I have to make a Sql query and only should show what from now on what is with a previous date can not be displayed. I have the problem that if I put it with DATETIME format it takes me the minutes and when I do the select what I just insert...
asked by 05.11.2017 / 20:07