username validation in php

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?

 

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