------------
 $sql = "SELECT username FROM main_users WHERE username = '$username'";

 $result = mysql_query($sql);

 $num = mysql_numrows($result);

 if ($num > "0") { die ("That username already exists, please chose
another"); }
-----------------
That could do it :)

- Kath

----- Original Message -----
From: "Brandon Feldhahn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, February 25, 2001 7:33 AM
Subject: [PHP] No same username


> how do i make somthing with my database that knows it the username
> entered is already a name in use?
>
>
> --
> PHP General 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 General 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]

Reply via email to