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.

Kemahiran: MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 5 ulasan ) Silver Spring, United States

ID Projek: #4035206

Dianugerahkan kepada:


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

$150 USD dalam 0 hari
(186 Ulasan)

4 pekerja bebas membida secara purata $175 untuk pekerjaan ini


Quality work assured. Ready to get started. Thanks.

$300 USD dalam 2 hari
(499 Ulasan)

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 dalam 4 hari
(109 Ulasan)

Ready to start..Waiting for hear from you. Thanks Benideas [login to view URL]

$100 USD dalam 2 hari
(2 Ulasan)