[john_zakaria]

room_type
rooms_no
persons
checkin
checkout

3 2 1 0000-00-00 0000-00-00
6 3 4 2008-11-14 0000-00-00
6 3 4 2008-11-14 0000-00-00
4 4 5 2008-11-14 2008-11-18

Now I have this table and I want to make SQL STATEMENT to make the following task

To see if the user can make a reservation in a hotel during the checkin and checkout date, by checking the numbers of rooms available in each room type during the checkin and checkout period of time
For example if the user enter number of persons that exceed the person that exists already in the database
And also to check if this period of time is available to make reservation according the the persons number


Note : rooms-type in this example are (3,6,6,4)
room_no in this example are (2,3,3,4)
person (1,4,4,5) -> number of persons

[DAL]

is row 2 and 3 a mistake as it seems it's a duplicate, if this is what your after stopping then it should be done in the php not the SQL as validating your data before writing it will always be the best programming ethic.

[john_zakaria]

do u mean that i have to do it using php not MYSQL?


row 2 and row 3 have no mistakes coz this is a trial to insert in database not to make this task
but i've attached this picture to let you see the table

[DAL]

MySQL is a database where you keep data, all of the cleaver handling and data manipulation comes from the code, in this case php.