Member Avatar for ajuv_001

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

hoteldb_model.png 54.04 KB
  • 2 Contributors
  • 3 Replies
  • 108 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by ajuv_001
Member Avatar for pritaeas

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.

Member Avatar for ajuv_001

thanx....i will try like this and let u know.....

Member Avatar for ajuv_001

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.