Hi,
assuming you have unique passwords.
$result = mysql_query("SELECT COUNT(*) AS used FROM userTable WHERE
passowrd=$password");
$exists = mysql_fetch_object($result);
if ($exists->used) {
....display error that pswd is already in use ....
}
If there is an entry in your DB with the password the _fetch_object contains
"used".
You can do the same thing for username and e-mail.
Johannes
""DC"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
9bfam9$jlm$[EMAIL PROTECTED]">news:9bfam9$jlm$[EMAIL PROTECTED]...
> Hi again
>
> How do i check my database when someone trys to become a member to check a
> see if
>
> username
> password
> email address
>
> is already in use and show the the bit they need to change for my script
to
> allow them to register.
>
> Thanks again in advance
>
> Dave C
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
