In Progress

MySQL Database Update

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.

Skills: MySQL, PHP, Software Architecture

See more: update database mysql, mysql update database, mysql database software, website database, php software architecture mysql, update status php mysql, mysql edit database, mysql search table, display mysql, mysql update field, status hold, mysql search database table, php search database table, mysql update table, mysql status, edit update, edit update php, php search database, update status, update display php, database task, update current, database software mysql, database display website, architecture database

About the Employer:
( 18 reviews ) Franklin, United States

Project ID: #1116827

Awarded to:

jamesbarrett

Hello, I can get this taken care of for you immediately. Please see PM.

$30 USD in 1 day
(1 Review)
1.4

38 freelancers are bidding on average $44 for this job

zeee

Please see PMB.

$50 USD in 1 day
(170 Reviews)
7.8
eelance

i can do that for you.mind show me more details?url?

$50 USD in 1 day
(353 Reviews)
6.8
natgeo

Please check PM. Thanks

$30 USD in 1 day
(109 Reviews)
6.8
mantislin

Hi sir, let me do it now!

$35 USD in 1 day
(135 Reviews)
6.6
gujjucoders

Hi, Let's finish it by the EOD. Check PMB for more details and exciting offer :)

$30 USD in 1 day
(88 Reviews)
6.5
freeworks

Please check my PM

$50 USD in 0 days
(78 Reviews)
6.4
GFsoul

sir i can fix this, just 1 hour required.

$30 USD in 1 day
(101 Reviews)
6.2
MustafaSR

Hello Sir, easy job, can do in a couple of hours.

$30 USD in 1 day
(76 Reviews)
5.7
ruimaxwell

Thank you.

$35 USD in 1 day
(50 Reviews)
5.6
surajddk

Hi, PHP, MySql Expert here, Let's start!

$30 USD in 1 day
(30 Reviews)
5.5
chongkan

Hi, I would like to be considered for this project.

$50 USD in 1 day
(7 Reviews)
5.3
yanotcook

I can fix within hours. Please check your PM for details.

$38 USD in 0 days
(43 Reviews)
5.3
atifmajeed12

Ready to do it now.

$30 USD in 0 days
(28 Reviews)
5.1
istankov85

Hi, lamaine. Ready to start. Regards, Ivan Stankov

$40 USD in 2 days
(37 Reviews)
5.0
mike25

Please check your inbox for remarks. Regards, Mike.

$40 USD in 0 days
(27 Reviews)
4.8
prasy8

Hi, please check p.m Thanks!

$30 USD in 1 day
(11 Reviews)
4.8
bdlancer09

Lets do it now.

$30 USD in 1 day
(47 Reviews)
4.6
MakeYouBelieve

Hi, I'm very interested this job and ready to start. Pls check your inbox. Thanks.

$30 USD in 0 days
(32 Reviews)
4.5
triadb

Hi, please check PM

$35 USD in 0 days
(11 Reviews)
3.9
jugal13

Hello sir, Please check the PM.

$30 USD in 0 days
(5 Reviews)
3.6