337787 MySQL/PHP questions answered

I have a few simple PHP and MySQL questions that I need answered. You can probably find these answers anywhere on the net. I'm just too busy to find them. QUESTION 1: I have a text file which has an XML file dumped into it. Each item in the file has a tag named ROWID. I need to update a MySQL database that already has related information in it. So, if there's an item with the ROWID value of 123, I need your script to update the row numbered 123 in the database. QUESTION 2: Let's say that I have a database with the field INFORMATION. Let's also say that INFORMATION is in the following format: "Jane Doe has been employed for XYZ Company since 2008" The INFORMATION field in all rows have "has been employed for" and "since" in them. But, Jane Doe, XYZ Company, and 2008 is dynamic data that will be different in each row. So, another row may read, "Bob Jones has been employed for ABC Unlimited since 2000" Your script should start deleting right after "for" and should stop deleting directly before "since" so that the result will be "Jane Doe has been employed since 2008" and "Bob Jones has been employed since 2000" for the other example. These are just examples and they should suffice for someone who actually is knowledgeable in this area. You cannot see the script, my server, etc. If you bid Immediate delivery, I will expect the script to be delivered within 20 minutes. In your bid, you must let me know the price for each question listed. Place the phrase not a bot in the PMB if you leave a message there. No portfolios, links to unrelated work, resumes, or statements in the PMB that you can do it. Escrow provided if requested in your bid. Don't bid if you can't do it in two hours. This needs to be done in PHP and needs to work on a shared server, where the user will more than likely not be able to access the [login to view URL] file or will have to reinstall PHP to get your script to work. Thanks. Good luck!