I know this should be an easy question, but I'm a beginner:
I have these 3 tables in my bank:
In this case, the purchased table is where the cpf of the user who purchased the course is stored and saves the course id. I think that's...
I made the following code
$data_restante = "SELECT DATEDIFF(CURTIME(),$data) AS date";
$result_data_res = mysqli_query($conn, $data_restante);
$dado_data_res = mysqli_fetch_assoc($result_data_res);
echo $dado_data_res['date'];
But it does n...
How can I use a foreach for this situation?
I would be selecting an element of the tabela dois - event - and for each event, get the tabela um data that also have the same event in its structure.
By the way, when aski...
I have a mysql column that has a key with value MUL , how to remove this setting from the command line?
My table has the following schema:
+-----------------+--------------+------+-----+-------------------+---------------------...
I need to do an onclick action on each option of a select with a different link according to each id, but it is not working.
$label .= "<select size=\"1\" name=\"modulo\" class='form-control'";
$label .= "<option value=\"0\" selected=\"...
Hello!
I have a question, is there a way to get information from one mysql database and insert into another one with tables having names?
example:
I want all the inserts of the bank 1 table name and insert into the bank 2 table username.
ho...
I am putting together a graph containing the number of CHATS that were answered at a given time, eg:
1-30s - > 20 chats answered
31-60s - > 66 chats answered
60-120s - > 4 chats answered
I'm confused on how to re...
I have little knowledge about SQL and would like to know if it is possible to do a SELECT on the same record (row), and for each cell value bring the corresponding record from a second table. Something similar to INNER JOIN, I believe.
Exampl...
The field is of type datetime, such as displaying the date for here 30 days from the date you registered, eg:
<?php
// 'data_cad' = '2018-03-01 01:52:00'
$instrucao = "SELECT
'user_id',
'status',...