username validation in php

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

lI am new to php coding. I'd need some 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?
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);

echo 'Username exist';
echo 'Unique Username';

hope this code can help