Sql Database crashes

Okay I have a game written in php
I can log on add users and such to the database but when someone else logs on and registers the database crashes and all data is lost and i have to use the table file to recreate it...Help Help Help...Thank you

what database is it, what version, what happens when it crashes, be as specific as possible and provide as much information as possible...

Okay im using
PHPDEV423
w/Apache 1.3.27
w/PHP 4.2.3
Mysql Database ~ Phpmyadmin
Windows 98
-------------
The database is stores user info and game stats...
But when ever someone else gets on the database dies...
Its still there in phpmyadmin but all tables are inaccessible, the files are still there under the my sql data folder...

OK, now post the code that is inserting this data into the database. This will be the next step in determining what might be going wrong

<?php include("head.php"); ?> Register to get your Indocron City account now, and begin the game. Password
will be Sent to E-mail.
<?php
$nump = mysql_num_rows(mysql_query("select * from players"));
print " <b>$nump</b> people already have.";
?>
<form method=post action=register.php?action=register>
<table>
<tr><td>Username:</td><td><input type=text name=user></td></tr>
<tr><td>Email:</td><td><input type=text name=email></td></tr>
<tr><td>Verify Email:</td><td><input type=text name=vemail></td></tr>
<tr><td>Referral ID:</td><td><input type=text name=ref> <i><br>If you don't know what this is, leave it blank.</i></td></tr>
<tr><td colspan=2 align=center><input type=submit value=Register></td></tr>
</form>

<?php
if ($action == register) {
if (!$user || !$email || !$vemail ) {
print "You must fill out all fields.";
include("foot.php");
exit;
}
$dupe1 = mysql_num_rows(mysql_query("select * from players where user='$user'"));
if ($dupe1 > 0) {
print "Someone already has that username.";
include("foot.php");
exit;
}
$dupe2 = mysql_num_rows(mysql_query("select * from players where email='$email'"));
if ($dupe2 > 0) {
print "Someone already has that email.";
include("foot.php");
exit;
}
if ($email != $email) {
print "The emails do not match.";
include("foot.php");
exit;
}
$ref = strip_tags($ref);
$user = strip_tags($user);
$pass = strip_tags($pass);
if ($ref) {
mysql_query("update players set refs=refs+1 where id=$ref");
}
$pass = rand(10000 , 90000);
$message = "welcome to $gamename your pass is $pass login now and change it. have fun playing at $gamename. Webmaster";
mysql_query("insert into players (user, email, pass) values('$user','$email','$pass')") or die("Could not register.");
mail("$email", "$gamename", $message,
"From: webmaster@{$_SERVER['SERVER_NAME']}rn"
."Reply-To: webmaster@{$_SERVER['SERVER_NAME']}rn"
."X-Mailer: PHP/" . phpversion()) or die("could not send mail");

print "You are now registered to play, $user. Please check your e-mail for your pass and login now.";
}
?>
<?php include("foot.php"); ?>

I don't see anything that jumps out at me,in fact it looks fine, but if you would like to do a dump of the DB and email it to me, I will try recreating it here and see if I can't reproduce the problem. If you would like me to give it a try, let me know and I will send you a Private Message that will include my email address.

Sure that is 1 of many filez...I can send u the entire db
my email is samman@endzone-electronics.NOSPAM.com

U know y
email me and ill send it to ya

I tried responding to your email address and it was rejected by your server...please provide a working address

Remove .NOSPAM
or click here

samman@endzone-electronics.com

i use the .NOSPAM so i dont get spam scanned