0

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

Attachments hoteldb_model.png 54.04 KB
2
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by ajuv_001
0

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.

0

dude....i 've written the search query that is working tooo.....thx yaar...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.