Missing records in mysql table

[mfoster]

I have a table of events that I have stored in a mysql (Mysql 5.0) table.  The table is accessed by a php script that allows the general public to view the events.  I have another program that allows me to add, delete, and edit the information in the table.  I am the only person that has access to that script.  However, the table randomly has records deleted despite the fact that I have not deleted them.  I have examined my scripts and can't seem to find any problems in them.  I have a number of other msql tables that do not exhibit this behavior.  My service provider finds nothing wrong with the tables.

 

Any ideas?

[toplay]

You might want to do a repair on the table(s) just in case.

 

How are you guaranteeing that you're the only person who has access to the delete functionality?

 

It might have to do with your code and how people can inject SQL. Make sure you're using mysql_real_escape_string() or mysql_escape_string() on values before inserting/updating/deleting in table.

 

Forum members won't be able to help much without seeing your actual code.

 

[burn1337]

I aggree with toplay, sqlinjection is very possible, I would also make sure nothing seems to be out of place on your server in the first place, even without sql injection could still be a sign of intrusion.