I am not able to perform a SQL query with N: N relationship. I have a user table and one with user_has_usuario self-relationship, which will be registered responsible and students (from a school) would like to list the students by the CPF of the...
In an input and output control system there is a cad_entrada_saida table where you have two columns in the dEntrada and dSaida database, these two columns are as varchar , and writing the data in the format dd/mm/yy...
How can I give MySql a INSERT or a UPDATE if the line in question already exists or not?
I tried the following but it did not work:
IF EXISTS (SELECT * FROM configs WHERE id_serie = :id)
UPDATE configs...
I make the following query from my apache server on a SQL SERVER database:
<?php
// Dados do banco
$dbhost = "192.168.0.100"; #Nome do host
$db = "DATABASE"; #Nome do banco de dados
$user = "root"; #N...
I have a table called sale and in this table I insert some data from another table until everything blz, my problem and at the time of showing this data when I do an echo on the screen does not appear the name of the product but yes his id and I...
I'm developing a plugin for members area in WordPress and I'm going to control this access through the roles functions.
Assuming I create the functions: content1, content2, and content3. How would I be able to assign more than one role to a...