added footer and sql and added room condition on products