Problems updating mySQL database after Slapper...

[Pontius]

My server recently got hit with the glorious Cinik variation of the Slapper virus, which I have since cleaned and scrubbed from my system, or so I thought. Before all this happened, I was using a php page I had written to update the SQL database, by doing a simple query:

$query ="update $tableID SET ... WHERE ...";
$result = mysql_query($query);

but now, after being hit with slapper, the php pages will pull the info from the database with no problems, but when I try to post anything to the DB using my php page with forms, it's not updating. in fact, I can't even use a simple php form page to pull info, unless the SELECT function is hardcoded into the php. I know the coding on the php pages are fine, as I've been using them for the past few months to update, delete, select, and do EVERYTHING from the simple form page. I've checked the coding on the server against the pages I printed out from the working code, and they are an exact match.

I can make changes directly on the server, by logging into mySQL using the exact same host, user, and password specified in my php file, and using the exact commands posted by the php page, but that becomes quite a pain when updates to the rather large database are made on a daily basis. Does anyone have any idea what may have happened to cause these problems or even better, a solution?

I have reinstalled mySQL and PHP making sure that nothing was corrupted by the lovely slapper, and still no results.

Any advice would be greatly appreciated.

 

[piti]

well, maybe you are using the <4.2 syntax of php

in versions lower than 4.2 to access the values passed from a form you simply use the variable named after the form field e.g. $name
from the 4.2 version there is some change in accessing these fields, if you use GET method, than it would be $_GET['name'], if POST - $_POST['name']

but i could be wrong - you have not mentioned if the updates are returning any errors