hmm, syntax help needed...

I need some help with the syntax here..
I want it to do alil validation before the insert, but a query find that username is unique first.

<?php
mysql_connect (localhost, u , p);
mysql_select_db (db);

$result1 = mysql_query ("SELECT * FROM members WHERE username = '$username'");

if ($row = mysql_fetch_array($result1))
{
print ("Error: The user name ");
print ("$USER_NAME");
print (" has been taken. Go back and enter a new user name.");
print ("<p>");
$verify = "bad";
}
elseif (eregi("[a-z]{2,16}", $firstname)
| | eregi("[a-z]{2,25}", $lastname)
| | eregi("[0-9a-z]{2,50}", $st1)
| | eregi("[a-z]{2,25}", $city)
| | eregi("[a-z]{2}", $st)
| | eregi("[0-9]{5}", $zip)
| | eregi("[0-9a-z]{6,16}", $username)
| | eregi("[0-9a-z]{6,10}", $password))
| | eregi("([_.0-9a-z-]+@)([0-9a-z][0-9a-z-]+.)+([a-z]{2,3})",$email)
{
mysql_query INSERT INTO members VALUES ('$firstname',
'$lastname', '$st1', '$city', '$state', '$zip', '$username',
'$password', '$email');
print mysql_error();
}else{
print 'failed';
}

?>

Thanx
Uga

You can try the following :


$result=mysql_query ("SELECT * FROM members WHERE username = '$username'");

if (mysql_num_rows[$result]==1){
print "Username has been taken already";
}else{

$insertresult=mysql_query ("INSERT INTO members(firstname,
lastname,st1,city,state,zip,username,password,email)VALUES ('$firstname','$lastname', '$st1', '$city', '$state', '$zip', '$username',
'$password', '$email')");

if (mysql_affected_rows($insertresult) == 1){

print "Record has been addedn";

}else{
print "Error while inserting record";
exit;
}
}


------------------
SR -
shiju.dreamcenter.net

[This message has been edited by Shiju Rajan (edited May 06, 2000).]

Thank you so much for a response, but will this also do the character validation that eregi would ?

Thanx,
Uga