Interested to Buy Any Domain ? << Click Here >> for more details...
In a property booking section want a query to check that
property is booked from StartDate to EndDate.Booking Table
field are given
id
proerty_id
start_date
checkout_date
no_of_visitor
booking date
status
Waiting yours answer..
Thanks In Advance...
- 1 Answers
- 3274 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhanshu_kmr
select * from property_table where
to_days(bookingdate)> to_days(startdate) and to_days(bookingdate)< to_days(enddate) ;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to shut down the server with 'mysqladmin'?
How we can get distinct columns values in mysql?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
How do you determine the location of mysql data directory?
What is database in php mysql?
How do I find my mysql username and password?
What is the current version of mysql?
What is the difference between mysql_connect and mysqli_connect?
What is the latest mysql?
How do I uninstall mysql connector?
What are the difference between and myisam and innodb?
How can I see connections in mysql?
Can we write pl sql mysql?
How do you kill a long running query in mysql?
