Jump to content

SQL data loss


alpha02

Recommended Posts

Hello!I have a table where I store the user names and passwords of the members. I use, when creating the account:$pass = $_POST["pass"];$pass = md5 ($pass);$pass = md5 ($pass);mysql_query ("INSERT INTO membres VALUES ('$user', '$pass')");//and I store this in a varchar(35) field.When I log in, it looks for the password in the db and compares it. It works, but sometimes the password juste disappears from the table and I have to go in phpmyadmin tu put it back. The validing page (login) has no script to modify the db. In phpmyadmin, it says :Loss: 60 bytesWhy does it happen? Please help! :)

Link to comment
Share on other sites

the only thing that comes to the top of my head, without knowing anything else about your situation, would be to check your db size and see if it exceeds the maximum your host allows. Also, make sure that your database size restriction includes nothing else.. In other words, your 1MB DB could still be in violation if your FTP space is counted together and that is 500MB - for instance.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...