I gang

Script to update my database

What I need is a script that checks this table for new vehicles and then adds them to the new vehicle_stats table.

Additionally the script (maybe a second script) checks the print_status table and updates vehicle_statistics when the first occurance of that vin being printed occurs

Then when the vehicle is no longer in the dealer_inventory table the vehicle_statistics entry for that VIN is updated as sold with the SOLD_DATE

2 other things, when the vehicle is printed I want the vehicle_statistics table to note the sticker print type, and when a vehicle is added its status is set to active, and when removed it's set to inactive

I basically need to know when vehicles are added to the system, when they are sold, what date the car was printed, the last scan date , and if the vehicle is active, or inactive and what type of sticker was printed.

Færdigheder: MySQL, PHP

Se mere: update status script php, script update database mysql, update status php mysql, status update script, occurance, mysql print script, mysql vin, status updates script php, vehicle database mysql, mysql update table, php script status updates, script entry database entry, vin database script, database script entry, status update script php mysql, print scan, php car database, vin php mysql, vin mysql database, database car, update status, vin database, status update php script, status update script php, update php car

Om arbejdsgiveren:
( 5 bedømmelser ) Silver Spring, United States

Projekt-ID: #4035206

Tildelt til:

VileGnosis

I have sent a private message to your inbox that contains my relevent skills and any questions I have.

$150 USD in 0 dage
(186 bedømmelser)
6.8

4 freelancere byder i gennemsnit $175 for dette job

rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$300 USD in 2 dage
(499 bedømmelser)
7.5
phpraza

Hi, I am a web developer with exeprtiese in php and mysql mainly and have 1year of experience in it I am interested in this job and can do for you If interested please contact me back Thanks

$150 USD in 4 dage
(109 bedømmelser)
6.0
benideas

Ready to start..Waiting for hear from you. Thanks Benideas [url removed, login to view]

$100 USD in 2 dage
(2 bedømmelser)
3.5