One of the dynamic elements that the client has requested is a database-driven section of the site that displays the motorcycles that are currently for sale. To accommodate this, a field called status has been created in the tbInventory table. This field is set to record either a 0 or 1 value, with 0 being for sale and 1 being sold. Before you can display the motorcycles that are for sale on the site, you need to build a recordset that contains only those motorcycles that are currently for sale.
|