I don't think that there's an easy way to do it in MySQL. I usually use
some hack along the lines of, "select x from t where x = $y", and if
there are any results returned, return a message of some sort ("That
value already exists in the database!").
Bear in mind that sometimes people have very similar contact
information. At the university where I used to work, there were two
employees who shared the same first, middle, and last names, as well as
birth dates, and their social security numbers differed by exactly one
digit. A rare circumstance, to be sure, but not impossible.
Dean Ouellette wrote:
> MySql
>
>
> At 10:10 AM 1/13/2002 -0800, Richard Crawford wrote:
>
>> Which database are you using?
>>
>>
>> Dean Ouellette wrote:
>>
>>> I am entering info from form into database, is there a way to check
>>> say firstname, lastname and address to see if it is a duplicate to
>>> what is already in database and if it is then just enter any new
>>> information they may enter and not create a new entry
>>
>>
>>
>>
>> --
>> Sliante,
>> Richard S. Crawford
>>
>> mailto:[EMAIL PROTECTED] http://www.mossroot.com
>> AIM: Buffalo2K ICQ: 11646404 Yahoo!: rscrawford
>> MSN: [EMAIL PROTECTED]
>>
>> "When you have lost the ability to laugh at yourself, you have lost
>> the ability to think straight." --Clarence Darrow
>>
>> "Push the button, Max!"
>>
>>
>>
>> --
>> 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]
>
>
>
--
Sliante,
Richard S. Crawford
mailto:[EMAIL PROTECTED]
http://www.mossroot.com
AIM: Buffalo2K ICQ: 11646404 Yahoo!: rscrawford
MSN: [EMAIL PROTECTED]
"When you have lost the ability to laugh at yourself, you have lost the
ability to think straight." --Clarence Darrow
"Push the button, Max!"
--
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]
