I need to select the Plaque, Employee Name, and Dependent Amount for each Employee, but the result of that query is showing the number of dependents for the first Employee only, / p>
Note: If you remove the WHERE clause, the query shows...
How to create a mysql view with 3 tables
the following structure being
cliente
|id_cliente
|nome_cliente
produto
|id_produto
|nome_produto
|valor_produto
pedido
|id_pedido
|id_produto
|id_cliente
I would like to create...
I have 2 mysql tables that represent the unavailable days for scheduling:
holidays table:
id, day (date), name
Special_days table :
id, day (date), will_work (boolean)
At the end I need to select the unavailable days which are the hol...
Hello, in a classified site with PHP and MySQL I made through Ajax the insertion of the state and the city. When selecting the state, the id is passed and it sends to the file getcidade.php that makes the select and returns the r...
I have two tables, Products and Orders.
I need to create a combobox for products and when the user chooses a product, the page has to display all requests related to the product, if I choose another product have to change the requests....
I have basically this relationships:
Iwouldliketogetthevalueofthe"im_fab_model" attribute of the "tblPrinter" table from the code of the "is_cod_printer" attribute of the table "tblPrinterPrinter", can anyone help me?
For now I have this sel...
My select works and returns the data I need, but it is returning more than 6000 times the same result.
How do I return the result in only 01 line.
NOTE: There is only one result for this code sq_transação , there is no possibility of...
I am developing a Specific Agenda for a client
but I'm not sure how to page the calendar per week.
The schedule works much more I do not know how to page now
date_default_timezone_set('America/Sao_Paulo');
$data1 = date('d/m/Y');
$hora1 = date...
I have the following query:
SELECT despesa.codRequisicao,
despesa.histDespesa,
despesa.despesaPassagem, despesa.despesaTaxi, despesa.despesaHotel, despesa.despesaRefeicao, despesa.despesaOutros
FROM...
How to total the days according to a period?
Example:
+--------------+--------------+--------+----------+
| data_ini | data_fim | codfun | qtd_dias |
+--------------+--------------+--------+----------+
| '2014-01-15' | '2014-01-31'...