Does username exist?

[Anon]

Hi, I've madea login system, that lets you sign up etc.... I have a problem though.
When you sign up, it doesn't check to see if the username you entered already exists in the Database... How can I make it do this?

[bastien]

use mysql_num_rows($result) when you query your DB. Do this first before executing the insert query.

$sql= "select * from usertable where username = $username";
$result = mysql_query($sql,$con);
if (mysql_num_rows($result)){
echo "username already exists. please choose another";
}else{
$sql2 = "insert into usertable values('$username', '$password')";
$result2= mysql_query($sql2)
}

hth

bastien

[mrmufin]

Make the username column a UNIQUE or PRIMARY KEY in the table. If the SQL INSERT fails, the username already exists...