What is the problem with this script?
PHP Code:<?php
mysql_connect (localhost, user, password);
mysql_select_db (nz);
$qry = mysql_query("SELECT user_name FROM DB_Wsers WHERE user_name='$user_name' LIMIT 1")
if ($_POST['action'] == 'save') {
if($_POST['user_password'] == $_POST ['user_password_confirm']){
$result = mysql_query ("INSERT INTO DB_Users Values ('','$user_name','$user_email','$user_password','$user_pending_flag','$user_suspended_flag','$user_moderator_flag','$user_admin_flag','$register_code','$user_real_name','$location','$age','$sex','$season_tkt_no')");
}else{
echo "Sorry";
}
$arr = mysql_fetch_array($qry);
if($arr[0] == ""){
$result = mysql_query ("INSERT INTO DB_Users Values ('','$user_name','$user_email','$user_password','$user_pending_flag','$user_suspended_flag','$user_moderator_flag','$user_admin_flag','$register_code','$user_real_name','$location','$age','$sex','$season_tkt_no')");
}else{
echo "That username is already in use.\n";
}
} else {
?>
Crap
<?php
}
?>
Reply With Quote