StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POneed updation for mysql query for choosing date range for reservation of a hotel room or any thing
primarykey
Id
3394723
data
AcceptedAnswerId
3583666
AnswerCount
3
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2010-08-03T08:13:10.620
FavoriteCount
1
LastActivityDate
2011-09-06T18:06:01.717
LastEditDate
2010-08-27T11:27:12.787
LastEditorUserId
55159
OwnerUserId
404128
ParentId
0
PostTypeId
1
Score
5
ViewCount
1627
LastEditorDisplayName
text
Body
i had a situation in my project that is as follows. while checking for the available rooms <pre><code>$sel_from_bookings="SELECT room_no FROM `booking` WHERE (('".$_POST['req_tdate']."' BETWEEN check_indate AND check_outdate) OR ('".$_POST['req_fdate']."' BETWEEN check_indate AND check_outdate)"; $sel_from_reserv="SELECT room_no FROM `reservation` WHERE (('".$_POST['req_tdate']."' BETWEEN check_indate AND check_outdate) OR ('".$_POST['req_fdate']."' BETWEEN check_indate AND check_outdate))"; $sel_rooms="SELECT room_no FROM rooms WHERE room_no NOT IN (".$sel_from_bookings.") AND room_no NOT IN (".$sel_from_reserv.")"; </code></pre> The first query retrives the list of room numbers from the booking table which satisfies the daterange similarly the second one dos same from the table reservation the last query uses the list provided by the above two queries and gets the list of room which are not in the generated list. works fine for 10-08-2010 / 15-08-2010 works fine for 20-08-2010 / 25-08-2010 when i give the dates between 10 and 15 it works fine similarly for 20 and 25 and also works fine for the dates 14-08-2010 and 21-08-2010 but not working for 16-08-2010 to 19-08-2010 need any clarification please ask me. Thanks.
Tags
<php><sql><mysql>
Title
need updation for mysql query for choosing date range for reservation of a hotel room or any thing
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USQuassnoi
UserOwnerUserId
1. USsrinivas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POneed updation for mysql query for choosing date range for reservation of a hotel room or any thing
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POneed updation for mysql query for choosing date range for reservation of a hotel room or any thing
 UserUserId
 USsrinivas
 VoteTypeVoteTypeId
 VTBountyStart
3. VO
 singulars
 PostPostId
 POneed updation for mysql query for choosing date range for reservation of a hotel room or any thing
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.