Or better using:
create table test1 (t1 char(5), t2 char(5), primary key (t1), unique (t2));
when creating table. No duplicate records with the same t2 because it's unique.
Ahmad Anvari
----- Original Message -----
From: Kath
To: Brandon Feldhahn ; [EMAIL PROTECTED]
Sent: Sunday, February 25, 2001 6:19 PM
Subject: Re: [PHP] No same username
------------
$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]
