I have a many-to-many relationship between two tables: Products and Orders.
Doctrine then generates a third table. Until then calm down.
But I wanted to generate in this third table more fields (qtde and unit value at the time of purchase)...
I'm migrating from a dbExpress system to FireDAC , the system is in three tiers >), I have changed components on the server side from SQLConnection to FDConnection , and SQLDataset to FDQuery , on the client side t...
I'm trying to show a table on the return of my insert but I'm not getting it, the insert operation is correct as well as the confirmation message, but the table is not displayed, I have this:
function GravaFase(event) {
event.p...
I have the following tables: negociacoes , negociacao_contatos and negociacao_status and the following relationships:
negociacoes hasMany negociacao_contatos
negociacoes belongsTo negociacao_status
In negociacao_stat...
I'm trying to list a particular product category. example.
$consulta = $pdo->prepare("SELECT * FROM msg where tema = :tema;");
$s = 'mensagens-de-aniversario';
$consulta->bindParam(":tema", $s, PDO::PARAM_STR);
$consulta->execute();
w...
What is the difference between relating 2 tables using and not using a foreign key?
Regarding performance, is it advisable to use foreign key to make the relationship?
In what situation would it be indispensable and in what situation would...
I'm trying to start a MySQL database connection and it works, but when I request that PHP display what it has there nothing appears. It's as if the connection to the BD had failed.
<?php
// definições de host, database, usuário e senha
$s...
I wonder if there is any way to calculate the difference between values that are in the same column. For example: I have a table with 2 fields: date and balance. I need to add a new field containing the balance difference from one date to anothe...
I have two tables:
category
--------
id | nome | imagem
user_follow_category
--------------------
id | from | to | date
Note: The relationship of the two tables is given by category.id and user_follow_category.to .
What I w...
I'm using n:m to create a system of attributes / characteristics for certain products, so I can reuse the same attributes for more than one product, the table looks something like:
WhenIexecuteaSELECTlikethis:SELECTPROD.idASPRODUTO_ID,...