Hi friends,
I am planning to develop a local hotel search engine. ive prepared the dbmodel and i've attached it with this thread. please help me to write search queries for searching hotel.
there are 11 tebles country,city,state,block,street,landmark,address,hotel,rooms,and amenities .
please go through the model i've attached and help me to write search queries for search hotel by city,street,block and hotel. after executing search query the result should contain values from every tables.every tables are linked through foreign key. i've tried but iam totally confused and i am not getting proper query...please help me......
thanks
Aju
ajuv_001
0
Newbie Poster
Recommended Answers
Jump to PostStart with writing smaller queries that solve part of the problem. Later on try to combine them to get a more complex result. If you have specific questions, post your query/queries and trouble/error here.
All 3 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Start with writing smaller queries that solve part of the problem. Later on try to combine them to get a more complex result. If you have specific questions, post your query/queries and trouble/error here.
ajuv_001
0
Newbie Poster
thanx....i will try like this and let u know.....
ajuv_001
0
Newbie Poster
dude....i 've written the search query that is working tooo.....thx yaar...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.