I want to search for the data into the database and replace for each index. I want to find a data like 3001, I want to set the data to a empty string and find the next data 3002 to replace it with 3001. Then I want to find the next data 3003 to replace it with 3002, find the next data 3004 to replace it with 3003, find the next data 3005 to replace it with 3004 and so on until find the last data 3010 to replace it with 3009. After the 3009 data is updated in the database, the next row that come after the 3009 data where it have a empty data, I want to input the 3010 data.
Here is the screenshot:
[url removed, login to view]
The reason why I want to search for the data and replace each of them, so I can use the index to find the data in the same row as the id to get the information I want.
Example: I want to find the data that start from 3001 to replace it with a empty string, then find the next data 3002 to replace it with 3001, find the next data 3003 to replace it with 3004 and so on then until to 3010 to replace it with 3009. So when the update is finish, I can use the id 3009 to search for the stop_date data to extract the data of 20161019130000 or extract to get the program title Bargain Hunt.
If you can do this, I would be happy to offer you $30 to do the quick small job. Thanks for your interest!!!