i use phpmaker simple reservation form but i need help because i known I know the initial level of php.
I get a reservation for a variety of occasions but i need to limit. would like to bring a certain limit for the same day.
I want to make a reservation to be entered to allow 40 per day
ut I do not have any idea of how to do
i use this database sample
CREATE TABLE IF NOT EXISTS reservations
(
ID
int(11) NOT NULL AUTO_INCREMENT,
Arrival Date
date DEFAULT NULL,
Arrival Time
tinytext,
Name Surname
tinytext,
Room Number
tinytext,
Adult Guest
int(11) DEFAULT NULL,
Children Guest
int(11) DEFAULT NULL,
VIP Guest
tinytext,
Reservation Officer
tinytext,
Chicken
int(11) DEFAULT NULL,
Fish
int(11) DEFAULT NULL,
Antrikot
int(11) DEFAULT NULL,
Additional Requests & Notes
text,
ResponseDateTime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1009 ;
Additional Requests & Notes
text CHARACTER SET utf8 COLLATE utf8_bin,
ResponseDateTime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1009 ;