Hi all,
I'm a novice in PHP. Here i have a problem. How can i create a new user account, by validating the existing ids presenting in the database.

  After checking for availability, If the user name already exists, options should be given to the user based on the first, middle and last name given bye the user itself..

Kindly someone help me,

Thanks in advance,
Prad.

find unique is username in database

$username = $_POST['username'];
///////
$query_advertiseleft = "SELECT * FROM useraccount WHERE username = '$username'";
$Recordset1 = mysql_query($query_advertiseleft, $cms) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$total_Recordset1 = mysql_num_rows($Recordset1);

if($total_Recordset1 == 0){

echo'SORRY ALREDY HAVE FOR THAT USERNAME';


}else{
///inserte the NEW ACCOUNT HERE:///

$sqlInsert = "INSERT INTO useraccount (artistid,name,category)
VALUES('$row_artist[id_artist]','$row_artist[artis_name]')";
$artist = mysql_query($sqlInsert, $cms) or die(mysql_error());


}

its not complete code ok i just show the mysql
MySQL Where,
MySQL Insert
cyber_kaley20@yahoo.com


caley