Simple.... do these checks.... and you'll be sweet as a nut
Adam
<?php
$sql = "SELECT nickname FROM tblUsers WHERE nickname = '$nickname''";
$result = mysql_query($sql);
$sql = "SELECT email FROM tblUsers WHERE email = '$email'";
$result2 = mysql_query($sql);
if (mysql_num_rows($result)){
$error[] = "That nickname is already chosen";
}
if (mysql_num_rows($result2)){
$error[] = "That username is already chosen";
}
if (!$error){
// do the inserting here
}
?>
// you might have this at the top of your form to show the error messages
<?php
if ($error){
echo "<p class=\"msg\">\n";
for($i=0;$i<count($error);$i++){
echo "$error[$i] . "<br>\n";
}
echo "</p>\n";
}
?>
> Hi all
>
>
>
> I am trying to create a registration area that uses a nickname and email
> pair.
>
>
>
> I need both to be unique.
>
>
>
> So how do I that either do not already exist then if unique insert into
> db.
>
>
>
> So
>
> if nickname exist then error = "sorry..."
>
> if email exist then error = "sorry..."
>
> else must be unique
>
> insert.
>
>
>
> I have been trying for hours know but cant get the twin check to work.
>
>
>
> Can get single check to work though.
>
>
>
> I thank you in advance for any thoughts or code examples
>
>
>
> Dave Carrera
>
> Php Developer
>
> http://davecarrera.freelancers.net
>
> http://www.davecarrera.com
