Error in registration form

Dakkar

I made a registration form and i want it to check from mysql if there is already a registered account name which you wanted .I tried lots of way but it didnt work.It always said your data inserted into database.
How can i make it work?

HTML VERSION

<html>
<body bgcolor="#FFFFFF" text="#000000">
<form action="kayit.php" method="get">
<b>Username:</b><input type="text" name="u_name" size="20">

<b>Password:</b><input type="password" name="pass" size="20">

<b>Email :</b><input type="text" name="mail" size="20">

PHP VERSION

@mysql_connect("localhost", "dakkar", "1234567")
or die("Couldnt connect with database");

$sira = 1;
$sorgu = mysql_query("select * from kayit where username='$u_name'");
$sonuc = mysql_result($sorgu, $sira, 'username');

if ($sonuc == $u_name) {
echo "<center><b>The username you wanted has already registered</b></center>";
} else {
@mysql_select_db("test")
or die("An error occured in database");

@("insert into kayit values('$u_name','$pass','$mail')");
echo "<center><b>Your data has inserted into database.</b></center>";
}

?>

LordShryku

Try this instead. It just counts...

$sql = "SELECT count(*)
          FROM kayit
         WHERE username = '".$_GET['u_name']."'";
$res = mysql_query($sql) OR die(mysql_error());
$row = mysql_fetch_row($res);
if($row[0] == 0) {
   // Username does not exist, insert it
}
else {
   // Username already exists
}

As always, you should script as if register_globals is off, even if you have them on.

Dakkar

Thanks so much