WEB 250 Project 2 - PHP/MySQL

For this project I need you to create five pages where each page will run one of the following statements from the previous project.

  1. We need to know the cabins that have two bathrooms.
  2. We also need to know the cabins that cost less than $220.
  3. Now we need to see all the cabins that have three or more bedrooms in Bryson City.
  4. Next we need to see all the rafting trips.
  5. The last thing we need to see is everything from the vacation package table and the notes pulled from the categories table. This should all be in one SQL statement. (HINT: It is a type of JOIN)

I have included the table information below.

Units Table and Structure
Units Structure Units Table

Vacation Packages Structure and Table
Vacation Packages Vacation Package Data

Vacation Package Categories Structure and Table
Vacation Categories Vacation Categories Data