Questions tagged as 'mysql'

Tagged questions
2
answers

How to consult between months or dates

I am trying to make a query to my table by specifying, taking an id, in specific: $id=$_GET['id']; $Consult= "SELECT * FROM pagos_colegio WHERE id='$id' AND mes BETWEEN ('jan' AND 'Dec'); "; $result= $conexion->query($Consult...
asked by 02.07.2016 / 12:35
1
answer

How to select only the first records of a ranking when there are several ranking groups from a procedure stored in MySQL?

I have the following procedure stored in MySQL, it works for me but nevertheless it brings me more records, I mean there are several records that coincide in almost all the fields except in the series and in the date, so I decided to order them...
asked by 18.08.2016 / 12:37
1
answer

Go from Linq to Sql

I have the following expression from Linq: Tabla.Skip(ind_pag).Take(cant_filas).ToList() How would it be on MySql ???     
asked by 20.08.2016 / 22:13
1
answer

calculate values of a dynamic table

What I want to do is calculate the values of the SubTotal field, since this is the result of the multiplication between the values of the Price field and the value entered in field text Quantity . In addition to calculating the VAT of the s...
asked by 24.06.2016 / 19:52
2
answers

help with login in php

I want to make a login with a previous record, so looking for me I found some tutorials, and this is the code to login: <?php session_start(); ?> <?php $host_db = "localhost"; $user_db = "root"; $pass_db = "123"; $db_name = "proyect...
asked by 08.06.2016 / 08:22
2
answers

Entity listener does not run correctly in JPA

I'm having trouble running the listeners correctly in JPA. The project uses: JPA 2.1. EclipseLink 2.6.3 MySql 5.7.11 I have an author entity marked with the annotation OneToMany and orphanRemoval = true to the entity Book, when in...
asked by 16.06.2016 / 16:00
2
answers

how to show an array, by post

I'm trying to insert and send some data through url, but I do not have the result, with a specific variable. require('conex.php'); mysql_connect($host,$user,$pass); mysql_select_db($database) ; if( isset($_POST["MM_insert"])){ for($i=0; $i...
asked by 16.06.2016 / 14:19
1
answer

Students registered in a project

In my system I have the ability to register students through a checkbox to a project, and remove it from it, it happens that I have not been able to limit students to only belong to a single project. At the time of registration they all appea...
asked by 26.05.2016 / 05:37
1
answer

Upload files with php and assign them to a specific ID of a table so that it can be downloaded later

I would like to add the option of uploading files to my system, but that these are connected or saved based on a record in the PROYECTO table, that when you open a certain project in a list you can download your digital file. that is:...
asked by 12.09.2016 / 00:54
1
answer

Condition values of a select to show students that make up a project and students who are not subscribed to a project

I have an option to enroll students to a project, previously there was the error that students or students who appeared in other projects could be enrolled several times, so change the sql query. this form shows the project and below it the s...
asked by 14.09.2016 / 00:11