username validation in php

pinku's Avatar, Join Date: Mar 2008
Newbie Member
hi,

lI am new to php coding. I'd need some help...im setting up a username/password system and need to be able to check whether a new username is unique. I have tired....can u help me?
0
mufaddal zirapurwala's Avatar, Join Date: Apr 2008
Newbie Member
U can do this by just a select query here is the solution

$query = "SELECT * FROM UserTable WHERE username=".$_Post['username'];
$Con = mysql_query($query, $connection) or die(mysql_error());
$row = mysql_fetch_assoc($Con);
$totalRows = mysql_num_rows($Con);

if($totalRows>0)
{
echo 'Username exist';
}
else
{
echo 'Unique Username';
}

hope this code can help