Questions tagged as 'mysql'

Tagged questions
1
answer

How to execute two MYSQL queries from netbeans

I would like you to help me. How to execute two queries to the same table from netbeans ?. Here the consultations: insert into tb_horarios(codigopersonal, dia, hora_entrada, hora_salida, numero_horas, malla_referencia, prd_codigo, j_codigo) s...
asked by 21.02.2018 / 15:07
1
answer

Add various details to a sale Django

I have 2 apps client and sale where the client has only one client table class Cliente(models.Model): nombre = models.CharField(max_length=100, verbose_name='Nombres') and sale has 2 tables (Sale and retail detail) and product but t...
asked by 25.01.2018 / 22:49
1
answer

get mysql data and send it by php to an email

my problem is this I have this code ' if (!empty($nombre) && !empty($correo) && !empty($mensaje)) { $nombre = trim($nombre); $nombre = filter_var($nombre, FILTER_SANITIZE_STRING); $correo = filter_var($correo, FILTE...
asked by 16.11.2017 / 18:36
2
answers

Place field that can be left blank or not

I have a couple of fields in mysql that I want them to be blank but I miss the error that I have to enter them and the problem is that they will not always be blank this is the insert of the data $Nombre = mysqli_real_escape_string($con,(st...
asked by 16.11.2017 / 15:02
1
answer

I need to capture the data of the select to do a mysql query with them and show the result in a table

<?php include_once 'rutas.php'; $host = "localhost"; $user = "root"; $pass = ""; $bd = "freire"; $con = mysqli_connect($host, $user, '', $bd) or...
asked by 10.11.2017 / 22:31
1
answer

Error Php Comments

Hi guys, I have this little mistake, they could help me solve it. if ($conexion) { $resultado = mysql_query("SELECT id, usuario, fecha, mensaje FROM comentarios ORDER BY id DESC", $conexion); while ($fila = mysql_fetch_row($resultado))...
asked by 10.11.2017 / 22:38
1
answer

Conceptual problem in database

Good evening. I am creating a database for a game, so to speak, but observing the Entity-Relationship model created for said database, I notice that I have some problems. We have the entities Players, Countries, Cells and Armies.    The en...
asked by 10.11.2017 / 22:31
1
answer

No suitable driver found for jdbc: mysql

To which other drivers are referenced or that I am not loading as I am loaded correctly, since if I do it for a main function this loads correctly     
asked by 11.11.2017 / 00:39
1
answer

Problems when making a query when grouping

I want a report like that friends: id descrip codigo nro idingreso bien bueno regular malo 01 aceite 2345 2 23 a 3 4 1 02 azucar 2345 4 34 b 2 5 2 I'm tryi...
asked by 07.11.2017 / 23:37
1
answer

Select Mysql Query

Good morning everyone before anything! Today I have a question like every day. I have this table in JavaFX as you can see I have 2 columns Placa y Km Sobrepasado So what I need to do here is load the data Plate and KmSobrepoasado fro...
asked by 07.11.2017 / 17:55