Questions tagged as 'sql'

Tagged questions
0
answers

Problems grouping query in CakePHP

I need to ask a question for a portfolio module in accounting, I have a sales table where I am bringing all the data and I group them for each client and add up the total of each client, I need you to bring me a list grouped by client and below...
asked by 31.10.2016 / 14:36
2
answers

Report three nested tables

I have the following nested tables, in SQL Server: ## Orden_Trabajo ## ID | TITULO | FECHA_INICIO | FECHA_TERMINO | EQUIPO --- 1 | FALLA MOTOR | 1/12/17 8:00 | 2/12/17 12:00 | 100 ## Tareas ## ID | TAREA...
asked by 11.12.2017 / 12:43
1
answer

Compare 1 to 1 rows in SQL

Good, moving forward a little more I came across another problem: I have the following table: Tabla1 +----+--------------------+-------------+-------+------------+ | Id | ultima_realizacion | vencimiento | tarea | id_cliente | +----+-------...
asked by 20.10.2016 / 22:18
1
answer

Error SQL query PHP

I am trying to create a registration form but when it comes time to perform the query to add the new user to the database, I do not mark any error and yet this new user does not appear in the table. $SQL = new PDO("mysql:host=localhost;dbname=...
asked by 11.03.2017 / 20:43
1
answer

How can you decrease the amount of a field in a column in Mysql?

Good, I hope you can help me, I'm doing a php and mysql system of a school about registration, what I want to do is the following: I have a student form where you put your data to register after this happens to the course form where I have the c...
asked by 18.07.2017 / 03:59
1
answer

How to know if a SQL was executed correctly, Symfony 2?

I use the following code to run an SQL file in my symfony 2.7 application, and it works, but I want to know how to validate if the query ran correctly or not. This is my code: public function importarAction(Request $request) { /**...
asked by 03.07.2016 / 07:22
1
answer

How can I recognize these 4 characters between "[GS]" as SQL and not as PhP?

In the following php query but it does not allow me to remove this [GS] that is in brackets within the table as a record (NOTE: Below I leave a small Photo SQL Capture of my doubt I appreciate answers I think the picture explains better.) $r...
asked by 16.07.2016 / 16:26
2
answers

Error convert varchar to int codeigniter sql server

Hi, I'm doing a simple application with CodeIgniter and sql 2000, which searches for records according to a client RUT, which is of type varchar. model: <?php defined('BASEPATH') OR exit('No direct script access allowed'); class Presta...
asked by 27.07.2016 / 23:04
1
answer

how can I open .dat and .idx files?

How can I open files and tables with extensions .DAT and .IDX using php? I am making a web application and I need to extract data from a database created by another program but I have not been able to do it, the files of the tab...
asked by 30.03.2016 / 15:34
1
answer

Select to records that do not contain value in table [closed]

I have the following table Pedimento | Partida | Identificador | Valor Agregado 6000001 | 1 | TL | 10 6000001 | 1 | PT | 10 6000002 | 1 | TL | 0 6000002 | 2 | XP | 0 6000003 | 3 | PT | 10 6000003 | 4 | TL | 10 How can I perform a query that...
asked by 11.02.2017 / 06:54