Hello, I'm setting up a hotel bank in MySql and would like to know how to add a condition for checkin and specific checkout date so there is no duplication of reservations in the period booked by the hotel. guest.
Thank you!
Lizypanta
What happens in practice when I omit begin transaction and commit in a PHP script using PDO?
I have a load script, which processes the school data, with each school that finishes processing I make a insert . This code belo...
I do not know about mysql, so it was very difficult to understand the Tuner diagnosis.
My problem is that when the site receives many visits, the connection to the bank falls. I'm using a Digital Ocean VPS with 2gb RAM
Following:
MySQLTuner...
I'm trying an INNER JOIN between 3 tables plus error returns, I do not know what's wrong.
Query:
SELECT
aa.arq_arqid,
aa.arq_nome,
aa.arq_nomecrip,
aa.arq_datetime,
u_usuarios_u_userid
a_area_a_areaid
FROM arq_arquiv...
I'm trying to make a report by joining 3 tables. But the table is not being generated. The query works in PHPMYADMIN, but not in php.
Database running Query
PHPcode$sql="SELECT fp_marca.marca as MarcaF,
fp_modelo.modelo as ModeloF,...
I have a problem with receiving and sending the data to the database because, when creating a system where there is the possibility of using the physical person or the legal person, they send to the same php page using the mode get I can show yo...
I'm developing a product page that lists within each category all related products (there are several categories and several products). As the code below, it 'runs' all categories and what I need to do, and where I need help, is to list the pro...
I have an application that works with facebook activity log, I have 150 pages under monitoring, and I do the daily insertion of these lines:
Post
Comment
Reply
Likes
Shares
It has reached 500 thousand records in 2 hours at most, b...
In my database I have 2 fields: "start_date" and "end_date".
From a current DateTime, I need to select all dates that are in the range where date_time > = start_date AND date_time < = end_data.
I did the following query and it did not work...
Good evening,
I have a system of control of inputs and outputs of computer repairs what I intend and that when I save the information in the database soon after I gave myself to print the html content of a div where the stored data will be re...