[PHP][MYSQL] Blokada... niedodawanie tych samych rekordów... Opcje

[Dizzy]

[PHP] pobierz, plaintext 
<?php
include 'Konfiguracja/Konfiguracja.php';
 
if (isset($_GET['user'])){ $user=$_GET['user']; } else { $user='';}
if (isset($_GET['acc'])){ $acc=$_GET['acc']; } else { $acc='';}
if (isset($_GET['pass'])){ $pass=$_GET['pass']; } else { $pass='';}
if (isset($_GET['notatka'])){ $note=$_GET['notatka']; } else { $note='';}
// Lista postaci.
if (isset($_GET['lp1'])) { $lp1 = $_GET['lp1']; } else { $lp1 = ''; }
if (isset($_GET['lp2'])) { $lp2 = $_GET['lp2']; } else { $lp2 = ''; }
if (isset($_GET['lp3'])) { $lp3 = $_GET['lp3']; } else { $lp3 = ''; }
if (isset($_GET['lp4'])) { $lp4 = $_GET['lp4']; } else { $lp4 = ''; }
if (isset($_GET['lp5'])) { $lp5 = $_GET['lp5']; } else { $lp5 = ''; }
if (isset($_GET['lp6'])) { $lp6 = $_GET['lp6']; } else { $lp6 = ''; }
if (isset($_GET['lp7'])) { $lp7 = $_GET['lp7']; } else { $lp7 = ''; }
if (isset($_GET['lp8'])) { $lp8 = $_GET['lp8']; } else { $lp8 = ''; }
if (isset($_GET['lp9'])) { $lp9 = $_GET['lp9']; } else { $lp9 = ''; }
if (isset($_GET['lp10'])) { $lp10 = $_GET['lp10']; } else { $lp10 = ''; }
if (isset($_GET['lp11'])) { $lp11 = $_GET['lp11']; } else { $lp11 = ''; }
if (isset($_GET['lp12'])) { $lp12 = $_GET['lp12']; } else { $lp12 = ''; }
if (isset($_GET['lp13'])) { $lp13 = $_GET['lp13']; } else { $lp13 = ''; }
if (isset($_GET['lp14'])) { $lp14 = $_GET['lp14']; } else { $lp14 = ''; }
if (isset($_GET['lp15'])) { $lp15 = $_GET['lp15']; } else { $lp15 = ''; }
if (isset($_GET['lp16'])) { $lp16 = $_GET['lp16']; } else { $lp16 = ''; }
if (isset($_GET['lp17'])) { $lp17 = $_GET['lp17']; } else { $lp17 = ''; }
if (isset($_GET['lp18'])) { $lp18 = $_GET['lp18']; } else { $lp18 = ''; }
if (isset($_GET['lp19'])) { $lp19 = $_GET['lp19']; } else { $lp19 = ''; }
if (isset($_GET['lp20'])) { $lp20 = $_GET['lp20']; } else { $lp20 = ''; }
 
$ip=$_SERVER['REMOTE_ADDR']; 
if (isset($user) && isset($acc) && isset($pass) && isset($note) && isset($ip)  ) {
       $check_query = mysql_query("SELECT * FROM users_extra WHERE user_acc='$acc' and user_pass='$pass'");
      if(mysql_num_rows($check_query)=="1") { echo 'Dane juz istnieja.'; }
      else{
$query = "INSERT INTO users_extra (id, user_login, user_acc, user_pass, user_notatka, new, user_ip, srv_type, player1, player2, player3, player4, player5, player6, player7, player8, player9, player10, player11, player12, player13, player14, player15, player16, player17, player18, player19, player20, user_date) VALUES (0 , '$user' , '$acc' , '$pass' , '$note', '1', '$ip', 'ViP', '$lp1', '$lp2', '$lp3', '$lp4', '$lp5', '$lp6', '$lp7', '$lp8', '$lp9', '$lp10', '$lp11', '$lp12', '$lp13', '$lp14', '$lp15', '$lp16', '$lp17', '$lp18', '$lp19', '$lp20', NOW())";
if (@mysql_query ($query)) {
echo "D";
} else {
echo $query;
echo mysql_error(); }
 
}
} else {
echo " NIE TAKI LINK ";
}
    
mysql_close();
echo " $check_query"; 
?>
[PHP] pobierz, plaintext 

I tak sie dodaje i tak...
echo " $check_query"; tresc:

Resource id #4

[Gacek89]

ale chcesz zeby do bazy niedodawał się identyczny wpis czy np niepowtarzały sie gracze

[pawelgdz]

W bazie danych w tej tabeli ustaw atrybut UNIQUE na polu user_login wtedy nie doda Ci sie ten sam rekord dla user_login. etc.

[erix]

Masz ustawione na kolumnę id atrybut auto_increment?

Jeśli tak, to wstawiaj null dla id, a nie zero.