Re: To check for existing user in database
| From: | Edmund Hertle | Date: | Thu, 15 Jan 2009 22:42:43 +0000 |
| Subject: | Re: To check for existing user in database | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-286471@lists.php.net to get a copy of this message | ||
2009/1/15 tedd <tedd.sperling@gmail.com>
> At 9:46 AM -0800 1/15/09, Chris Carter wrote:
>
> Chris:
>
> That's not the way I would do it. After establishing a connection with the
> database, I would use the query:
>
> $query "SELECT email FROM owners WHERE email = '$emailAddress' ":
> $result = mysql_query($query) or die(mysql_error());
>
> if(mysql_affected_rows())
> {
> // then report a duplicate email/record.
> }
> else
> {
> // else insert a new record in the dB.
> }
>
> HTH's
>
> tedd
You should not forget to use mysql_real_escape_string() just as Daniel Brown
explained...
-eddy