I have a website database that has several tables. One of the fields in one of the tables is a license status. Currently it is varchar. We need to be able to easily change this license status to active or inactive. When the php search is ran only people that have a license status of "active" would be displayed. When they pay their license fee we will change their status from "inactive" to "active".
Task: 1. Change database field in table to hold "active" or "inactive. Or it could be "license_status_active", Yes or No.
2. Edit current php search to display only "active" people in database.