I have a php script which connects to another website and copies data from it and submits it into my database. This is all working fine.
The script runs a check to see if any products have been removed from the site we are copying from. If it cannot find a product on the site and the product in question is in a hard coded list of category ids then it updates the product record in my db in 2 fields. This all works fine.
I need some code adding to that rule which would stop that that rule from working if the product in the db has a record in another table in the DB.
For an expert php/mysql developer this should take about 30 minutes. I know all the tables/fields so can help you do it quickly.
The code is live and the code runs live on the data so cannot go wrong. For this reason I only want HIGHLY skilled programmers to bid.
The task must be done online while i am on IM with you.