Re: How to prevent duplicated values?
| From: | Mario | Date: | Mon, 26 Jan 2004 09:47:20 +0000 |
| Subject: | Re: How to prevent duplicated values? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-175737@lists.php.net to get a copy of this message | ||
Run a select first to check whether you have that value stored and by using
an "if" statement add the new value or show an error.
----- Original Message -----
From: "BAO RuiXian" <ruixian.bao@pp.inet.fi>
To: "Radwan Aladdin" <raladin@emirates.net.ae>
Cc: <php-general@lists.php.net>
Sent: Monday, January 26, 2004 11:35 AM
Subject: Re: [PHP] How to prevent duplicated values?
>
>
> Radwan Aladdin wrote:
>
> >Hello..
> >
> >I want to prevent mySQL from storing the same value in a specified field
(Username).. so how can I do it?
> >
> >Regards..
> >
> >
> Make it field UNIQUE.
>
> Best
>
> Bao
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>